Use of IF

[Guest]

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

 

[Guest]

Try:

=IF(A19=0,-E26,-e27)

 

[Guest]

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

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.