Hello all, first time poster, long time reader.
I have a formula that I am trying to create that is not working. I’ve searched but can’t find the right formula or I’m going about it all wrong.
It references a cell (A1) and return a function in another cell (D1). It goes like this:
If cell A1 is between 1-10 then “test 1” in cell D1,
If A1 is between 11-20 then “test 2” in cell D1,
If A1 is between 21-30, then “test 3” in cell D1
Thank you in advance for any help.
Bookmarks