software

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=gt;0 then -E27

Thanks in advance

Try:

=IF(A19=0,-E26,-e27)
--
Gary's Studentquot;Kjellquot; wrote:

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

quot;Kjellquot; wrote:
gt; I need a formula for the following and is not able to
gt; get the function to work: IF A19 =0 then -E26 OR
gt; A19=gt;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 A19lt;0. The best we can do is something like:

=if(a19 = 0, -e26, if(a19 gt; 0, -e27, quot;quot;))

The last part (quot;quot;) leaves the cell blank if A19lt;0. If you
want something else, replace the last part.