a greater than less than formula

Marq

Well-known Member
Joined
Dec 13, 2004
Messages
854
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?
 

Some videos you may like

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

Watch MrExcel Video

Forum statistics

Threads
1,114,407
Messages
5,547,774
Members
410,811
Latest member
adustin42
Top