Formula Problem

[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")

 

[FSt1]

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

 

[Max]

Maybe you meant:
=IF(AND(E2>0,G2>0),"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

 

[T. Valko]

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(E2>0,G2>0),"Table",IF(F2>0,"Chair","Stool"))

For equals 0:

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