M Marq Well-known Member Joined Dec 13, 2004 Messages 854 Oct 27, 2006 #1 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?
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?
N njimack Well-known Member Joined Jun 17, 2005 Messages 7,764 Oct 27, 2006 #2 Formula in B1: Code: =IF(A1<12,12,IF(A1<25,24,IF(A1<37,36)))
M Marq Well-known Member Joined Dec 13, 2004 Messages 854 Oct 27, 2006 #3 works perfect, ......thanx!!