Sorry that I was not clear in my question. *I do no 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 > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > >
