IF formula

W

walkerT

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!
 
E

Elkar

You need to specify your false condition in the formula:

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

HTH,
Elkar
 
Top