How to update cell values based on different criteria
First of all, thank you all for all the support you provide here. It has been very useful in my training journey.
Now I am working on a report where I have to put data based on % value, so the total % is in a line item and in new line item, I am trying to rank it based on %. I am trying below formula, but it seems not working.
IF Cumulative QTY <=70% THEN "A" ELSE IF Cumulative QTY >70% AND Cumulative QTY < 90% THEN "B" ELSE "C"
Any help and pointers are highly appreciated.