Yes I was confused. I am still confused about some of the formulas I am using but enough for now. Thank you for all the help.
On Mon, Sep 7, 2009 at 2:38 PM, Brian Barker <[email protected]>wrote: > 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] > >
