Use of IF

K

Kjell

I am a new user of excel and have a question. I need a formula for the
following and is not able to get the function to work:
IF A19 =0 then -E26 OR A19=>0 then -E27

Thanks in advance
 
J

joeu2004

Kjell said:
I need a formula for the following and is not able to
get the function to work: IF A19 =0 then -E26 OR
A19=>0 then -E27
Click to expand...

The requirement is ambiguous because you want both
-E26 and -E27 if A19=0. Moreover, you fail to say what
you want if A19<0. The best we can do is something like:

=if(a19 = 0, -e26, if(a19 > 0, -e27, ""))

The last part ("") leaves the cell blank if A19<0. If you
want something else, replace the last part.
 
Top