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!

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!

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!