I need a formula to show this logicif the data in b7 is > than 4.31 then show a 1 if > 8.62 show a 2

if the data in b7 is > than 4.31 then show a 1 if > 8.62 show a 2

Try:=IF(AND(B7<8.62,B7>4.31),1,IF(B7>8.62,2,""))MIKEhttp://www.skeptic.com/

=IF(AND(B7<8.62,B7>4.31),1,IF(B7>8.62,2,""))

MIKE

http://www.skeptic.com/