| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
IF Formuala
the formula that I am trying does not return the results that I need.
=IF(C16<="14-Sep-05",SUM(F16*$S$1),IF(C16="15-Sep-05",SUM(F16*$S$2))) Cell C16= date Cell F16= Kilometers Cell S1=0.37 and Cell S2=0.40 The result I am getting is for the first part of the formula and not for the second part when the date is greater than or equal to 15-Sep-05. |
|
#2
|
|||
|
|||
|
put your date text strings inside the DATEVALUE() function
=IF(C16<=DATEVALUE("14-Sep-05"),SUM(F16*$S$1),IF(C16=DATEVALUE("15-Sep-05)",SUM(F16*$S$2))) "PW" wrote: the formula that I am trying does not return the results that I need. =IF(C16<="14-Sep-05",SUM(F16*$S$1),IF(C16="15-Sep-05",SUM(F16*$S$2))) Cell C16= date Cell F16= Kilometers Cell S1=0.37 and Cell S2=0.40 The result I am getting is for the first part of the formula and not for the second part when the date is greater than or equal to 15-Sep-05. |
|
#3
|
|||
|
|||
|
I suspect you have real dates in C16 but in your formula you are using text
Try =IF(C16<=DATE(2005,9,15),......... best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "PW" wrote in message ... the formula that I am trying does not return the results that I need. =IF(C16<="14-Sep-05",SUM(F16*$S$1),IF(C16="15-Sep-05",SUM(F16*$S$2))) Cell C16= date Cell F16= Kilometers Cell S1=0.37 and Cell S2=0.40 The result I am getting is for the first part of the formula and not for the second part when the date is greater than or equal to 15-Sep-05. |
|
#4
|
|||
|
|||
|
Thank you for your help. The formula now works.
Have a great day PW "Duke Carey" wrote: put your date text strings inside the DATEVALUE() function =IF(C16<=DATEVALUE("14-Sep-05"),SUM(F16*$S$1),IF(C16=DATEVALUE("15-Sep-05)",SUM(F16*$S$2))) "PW" wrote: the formula that I am trying does not return the results that I need. =IF(C16<="14-Sep-05",SUM(F16*$S$1),IF(C16="15-Sep-05",SUM(F16*$S$2))) Cell C16= date Cell F16= Kilometers Cell S1=0.37 and Cell S2=0.40 The result I am getting is for the first part of the formula and not for the second part when the date is greater than or equal to 15-Sep-05. |
|
#5
|
|||
|
|||
|
THank you for your help. The formula now does work.
Have a great day PW "Bernard Liengme" wrote: I suspect you have real dates in C16 but in your formula you are using text Try =IF(C16<=DATE(2005,9,15),......... best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "PW" wrote in message ... the formula that I am trying does not return the results that I need. =IF(C16<="14-Sep-05",SUM(F16*$S$1),IF(C16="15-Sep-05",SUM(F16*$S$2))) Cell C16= date Cell F16= Kilometers Cell S1=0.37 and Cell S2=0.40 The result I am getting is for the first part of the formula and not for the second part when the date is greater than or equal to 15-Sep-05. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
