PDA

View Full Version : [SOLVED] Formula to Return value when a cell falls between two values



leemcder
10-15-2018, 11:23 AM
Hi can anyone help me with a formula to return values between two numbers,

I want anything between 0 to 0.99999 to return "0>1", 1 to 1.99999 to return "1>2" , 2 to 2.9999 return "2>3", 3 to 3.9999 return "3>4", 4 to 4.9999 return "4>5" and anything 5 and over to return "5+"

Does anyone have any ideas how to do this?

Thank you

Paul_Hossler
10-15-2018, 11:38 AM
This seems to work




=IF(AND($A1>=0,$A1<1),"0>1",IF(AND($A1>=1,$A1<2),"1>2",IF(AND($A1>=2,$A1<3),"2>3",IF(AND($A1>=3,$A1<4),"3>4",IF(AND($A1>=4,$A1<5),"4>5","5+")))))



23030

leemcder
10-15-2018, 11:46 AM
Thanks Paul, this is perfect!
This seems to work




=IF(AND($A1>=0,$A1<1),"0>1",IF(AND($A1>=1,$A1<2),"1>2",IF(AND($A1>=2,$A1<3),"2>3",IF(AND($A1>=3,$A1<4),"3>4",IF(AND($A1>=4,$A1<5),"4>5","5+")))))



23030