# Mark Numbers Between Numeric Range, Above Or Below

• I am looking for some assistance on how to put together a function that will provide for me 1 of 3 results, (lower than, higher than or similar to).

What I would like to do is have a function to have the results for column B, be either "lower than", "higher than" or "similar to" based on column A. Column A will have a range of %'s from -100% to 100%

What I would like happen is the following results for cloumn B, based on column A.

If Column A is:

Between -5% and 5% - Then cloumn B = "similar to"
>5% - Then cloumn B = "higher than"
>-5% - Then cloumn B = "lower than"

Thank you,

• Re: If And Function

In B1 and copy down:

=IF(A1<-0.05,"lower than",IF(A1>0.05,"higher than","similar to"))

• Re: If And Function

Thank you!!!

• Re: If And Function

pmgmd, if assume your answer in thread titles again I will ban you. 1st and ONLY warning.

## Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!