At 08:49 07/09/2009 -0600, Walter Hildebrandt wrote:
Sorry that I was not clear in my question. *I do not care if any of
the cells are empty. I only want to determine if all the cells (A1
B1, C1 D1 and F1) are equal to 0 (zero) or are greater than 0, then
F1 will be Yes. If any of the cells are a negative number then F1 will be No*
On Sun, Aug 23, 2009 at 10:02 AM, Brian Barker
<[email protected]>wrote:
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
You'll have to excuse my giggling! You posted a question
earlier. But then you apparently found a fifteen-day-old reply from
me to a quite different question you had also posed, and have now
interpreted this as a surprisingly prescient reply to your current
question. Perhaps you were confused by the fact that you gave the
two questions almost identical subjects?
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
