software

How do I write down a formula using conditionals to obtain 3 different values?
If Cell 1 and Cell 2 are higher than quot;Zeroquot;, I need to check if Cell 1 is
higher than Cell 2 then the answer is quot;Aquot; but if Cell 2 is higher than Cell 1
the answer is quot;Bquot;, but if both are quot;Zero, the answer is quot;Cquot;


=IF(OR(A1lt;0,B1lt;0),quot;one neg.quot;,IF(A1gt;B1,quot;Aquot;,IF(B1gt;A1,quot;Bquot;,quot;Cquot;)))

--
Greetings from New Zealand
Bill K

quot;Salvador Enríquez Mquot; gt; wrote in
message ...
gt; How do I write down a formula using conditionals to obtain 3 different
gt; values?
gt; If Cell 1 and Cell 2 are higher than quot;Zeroquot;, I need to check if Cell 1 is
gt; higher than Cell 2 then the answer is quot;Aquot; but if Cell 2 is higher than
gt; Cell 1
gt; the answer is quot;Bquot;, but if both are quot;Zero, the answer is quot;Cquot;