jbclem

The rest of the solution is the = sign before the If Statement.
=IF(N44="L", M44-L44, L44-M44)

Mike Rogers


"Rookie 1st class" wrote:

in O44 I pasted
=IF(N44="L", M44-L44, L44-M44)
L44 = 5
M44 = 10
if N44 = L answer in O44 = 5, if N44 anything besides L = -5
the " " around the text L are the secret.
Lou

"jbclem" wrote:

I'm using Excel 2002 for the first time and trying to place a function into a cell. I 'm using IF(N44=L, M44-L44, L44-M44) .
Which is supposed to mean If the letter L is in cell N44, then subtract number in L44 from number in M44. Otherwise subtract M44 from L44.

If have 2 main questions...First, how to get the result of the function to show. Right now I see the function typed out in the cell, but no result. Help files say use CNTL and + and accent grave. Unfortunately, my english keyboard has no accent grave, so I'm stumped right there. I haven't found another way to get the results to show.

Second...can I use the letter L in N44 to trigger this function, or does it have to be another number?


Any suggestions?

jc