View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
jbclem jbclem is offline
external usenet poster
 
Posts: 33
Default Basic IF function help needed

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