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