Hi

What I'm after
If cells E and G are 0 I want the cell to show Table and if cell f is 0 I
want the cell to show Chair otherwise i want the cell to show stool -

I have the following formula which is not working - what have I done wrong
please?

=IF(AND(E2=0,G2=0),"Table")*IF(F2=0,"Chair","Stool ")
--
Thanks

Lise

hi
not sure about the Table, Chair and Stool part but there does seem to be a
syntax problem with the formula. try this...
=IF(AND(E3=0,G3=0),"Table",IF(F3=0,"chair","Stool" ))

does this do what you want?

regards
FSt1

"Lise" wrote:

Hi

What I'm after
If cells E and G are 0 I want the cell to show Table and if cell f is 0 I
want the cell to show Chair otherwise i want the cell to show stool -

I have the following formula which is not working - what have I done wrong
please?

=IF(AND(E2=0,G2=0),"Table")*IF(F2=0,"Chair","Stool ")
--
Thanks

Lise

Maybe you meant:
=IF(AND(E20,G20),"Table",IF(F2=0,"Chair","Stool" ))

Test it out, satisfy yourself that it returns the full range of expected
values dependent on the full range of values that may be input/arise in E2,
G2 and in F2. Note that since the IF evaluates from left to right, once the
1st IF test returns TRUE, you'd get: Table, irrespective of the result of the
2nd IF, which will never get evaluated.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"Lise" wrote:
What I'm after
If cells E and G are 0 I want the cell to show Table and if cell f is 0 I
want the cell to show Chair otherwise i want the cell to show stool -

I have the following formula which is not working - what have I done wrong
please?

=IF(AND(E2=0,G2=0),"Table")*IF(F2=0,"Chair","Stool ")
--
Thanks

Lise

In your explanation you mention greater than 0 as the condition but in your
formula you're testing for equal to 0.

Try one of these:

For greater than 0:

=IF(AND(E20,G20),"Table",IF(F20,"Chair","Stool" ))

For equals 0:

=IF(AND(E2=0,G2=0),"Table",IF(F2=0,"Chair","Stool" ))


--
Biff
Microsoft Excel MVP


"Lise" wrote in message
...
Hi

What I'm after
If cells E and G are 0 I want the cell to show Table and if cell f is 0
I
want the cell to show Chair otherwise i want the cell to show stool -

I have the following formula which is not working - what have I done wrong
please?

=IF(AND(E2=0,G2=0),"Table")*IF(F2=0,"Chair","Stool ")
--
Thanks

Lise