Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF formula
I am trying to use an IF fromula but it keeps giving me a false statement.
Here is the formula I am using =IF(+F9M9,F9+M9) I want the formula to use M9 if it is greater than F9 or if M9 is less than F9 then use F9 + M9 but it keeps coming up with a false statement Any help would be much appreciated! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF formula
You need to specify your false condition in the formula:
=IF(F9M9,F9+M9,M9) HTH, Elkar "walkerT" wrote: I am trying to use an IF fromula but it keeps giving me a false statement. Here is the formula I am using =IF(+F9M9,F9+M9) I want the formula to use M9 if it is greater than F9 or if M9 is less than F9 then use F9 + M9 but it keeps coming up with a false statement Any help would be much appreciated! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF formula
try
=if(F9m9,F9+M9,M9) "walkerT" wrote: I am trying to use an IF fromula but it keeps giving me a false statement. Here is the formula I am using =IF(+F9M9,F9+M9) I want the formula to use M9 if it is greater than F9 or if M9 is less than F9 then use F9 + M9 but it keeps coming up with a false statement Any help would be much appreciated! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|