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"