formula problems

[kendals]

Hi, using the formula below i want to add a statement that says if c34 and e34 are the same then to say top floor, as it would be the top floor management who would decide where stock goes.

 =IF(C34>D34,"Lower Floor",(IF(D34>E34,"Middle Floor","Top floor")))

[/code]

 

[Dan Waterloo]

=IF(AND(C34>D34, C34<>E34),"Lower Floor",(IF(AND(D34>E34, C34<>E34),"Middle Floor","Top floor")))

 

[kendals]

not working

i managed to do it using this:

=IF(AND(C3>D3,C3>E3),"Tier 1",IF(AND(D3>C3,D3>E3),"Tier 2",IF(AND(E3>C3,E3>D3),"Tier 3","Tier 3")))

thanks

 

[Dan Waterloo]

You should check your last clause though. You have it resulting in "Tier 3" whether the condition is true OR false.