Hi guys,
I got this formula which should be simple, but for some reason can't make it work.
Original one is:
=(IF(AND(AA5>10%,AA5<19.999%),"C")
and it returns result C, so all good here.
But trying to blend few criterias, and nothing happens, I get ERROR.
Basically, the goal is: IF values are between IF below 10% show D, IF between 10%-19.99%, show C, IF between 20%-29.99% show B, IF >= 30% show A
How do I blend these together, please?
Bookmarks