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