If condition based on the values

Hi,

Need your help please.

I have numbers in column A. I am trying to write an IF condition formula. If the number in A2 is between 0 and 1 like 0.5, 0.8 etc, the result needs to come as "0 to 1". In the same way if the number in A2 is between 1 and 2, result is "1 to 2". A2 having number between 2 and 3, result is "2 to 3". A2 having any number more than 3 need to come as "more than 3"

Originally Posted by AliGW

Try this:

=LOOKUP(A1,{0,1.000000001,2.0000000001,3.000000001},{"0 to 1","1 to 2","2 to 3","More than 3"})

or this (depending on what you want to happen):

=LOOKUP(A1,{0,1,2,3},{"0 to 1","1 to 2","2 to 3","More than 3"})

Thank you so much and both the formulas are working as expected..

Originally Posted by HansDouwe

Or try

Formula:

Please Login or Register  to view this content.

or this depending what should happen:

Formula:

Please Login or Register  to view this content.

Thank you so much.. The formulas are working as expected..