IF formula

[Guest]

I am trying to use an IF fromula but it keeps giving me a false statement.

Here is the formula I am using =IF(+F9>M9,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!

 

[Guest]

You need to specify your false condition in the formula:

=IF(F9>M9,F9+M9,M9)

HTH,
Elkar

 

[Guest]

try
=if(F9>m9,F9+M9,M9)