L
Lise
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")
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")