At 09:39 23/08/2009 -0600, Walter Hildebrandt wrote:
Is there a formula that will do the following?
1 If A1 is empty, Emt appears in C1
2 If A1 is a negative number, Neg appears in C1
3 If A1 has a 0 (a zero), Zero appears in C1
4 If 1, 2, and 3, above, do not exist then C1 is the percentage by
which A1 is greater then B1
Try:
=IF(ISBLANK(A1);"empty";IF(A1<0;"negative";IF(A1=0;"zero";(A1-B1)/B1*100)))
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
