Search : in
By :

Help with excel IF formula

Last answer on Oct 9, 2009 3:38:50 am BST kirstybill, on Oct 8, 2009 1:33:35 pm BST 
 Report this message to moderators

Hello,

I am trying (hard) to work out the following but everytime I put a formula in I just can't seem to get it right so am looking for some help.

IF C2 >=£0.01 and <=£0.99 then "£0.00"
IF C2 >=£1.00 and <=£4.99 then "£0.15"
IF C2 >=£5.00 and <=£14.99 then "£0.25"
IF C2 >=£15.00 and <=£29.99 then "£0.50"
IF C2>=£30.00 and <=£99.99 then "£1.00"
IF C2>=£100 then £1.30

Thanks in advance.

Kirsty

Configuration: Windows XP Internet Explorer 6.0

Best answers for « Help with excel IF formula » in :
Basic Excel Formulas ShowBasic Excel Formulas Below are some basic formulas for Microsoft excel: Basic formula : ADDITION cell A1 to A10 = sum (A1: A10) AVERAGE cell A1 to A10 = average (A1: A10) MAXIMUM cell A1 to A10 = max (A1: A10) MINIMUM...
Basic Excel Formulas 2 ShowBasic Excel Formulas 2 We saw the SI function Function and is also interesting. Combined with SI, this gives: = IF (AND (condition1; condition2 ;....... conditionZ) true false) displays on the various conditions to be verified (eg...
[Excel] Adding a fixed date in a cell Show[Excel] Adding a fixed date in a cell If you want to insert the current date in a cell in following format DD /MM/YYYY, and that it remains unchanged, without being updated each time the file is opened. Simply type "ctrl" + ";" in the...
Spreadsheets - Mathematical Functions ShowStandard Functions Function Description ABS() This function returns the absolute value of a number. It therefore returns the number, if it is positive, or the opposite (positive) if it is negative ODD(value) Rounds a number up to the...
Ask your question Reply

1

sharpman, on Oct 8, 2009 6:34:46 pm BST

Do a search on google for nested if statements in excel

   
Reply to sharpman

2

 venkat1926, on Oct 9, 2009 3:38:50 am BST
  • +1

=IF(AND(C2>=0.01,C2<=0.99),0,IF(AND(C2>=1,C2<=4.99),0.15,IF(AND(C2>=5,C2<=14.99),0.25,IF(AND(C2>=15,C2<=29.99),0.5,IF(AND(C2>=30,C2<=99.99),1,IF(C1>100,1.3,0))))))

It is a long formula. study this formula with "and"s, brackets etc you can crate your own formula next time.

there are six ifs. in versions before excel 2007 there can be only maximum of seven ifs

   
Reply to venkat1926
Ask your question Reply
They need your help