Use of IF
 

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

Use of IF
 

Try:

=IF(A19=0,-E26,-e27)
--
Gary's Student


"Kjell" wrote:

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

Use of IF
 

"Kjell" wrote:
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.