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
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