Excel "AND" formula help

September 19, 2010 at 14:54:04
Specs: Windows XP
I need a formula to show this logic

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


See More: Excel "AND" formula help

Report •


#1
September 20, 2010 at 12:46:29
Try:

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

MIKE

http://www.skeptic.com/


Report •
Related Solutions


Ask Question