how would I make a formula to do the following:
if A1 is less than 12 then make B1 equal 12, but is cell A1 is greater then 12 but less than 25 then make B1 equal 24......IF A1 is greater than 24 but less than 37 then B1 equals 36
anyone?
if A1 is less than 12 then make B1 equal 12, but is cell A1 is greater then 12 but less than 25 then make B1 equal 24......IF A1 is greater than 24 but less than 37 then B1 equals 36
anyone?