Forum Discussion
Solved
IF statement help please
Hi How do I write an IF statement if I want it to look for different ranges and if that meets certain criteria to do a SUM calculation. For example So if range is 'Low' I want it to add 1.5%...
In AD2:
=AC2*IF(AB2="Low",101.5%,IF(AB2="Mid",101%,IF(AB2="High",100.5%)))
or
=AC2*IFS(AB2="Low",101.5%,AB2="Mid",101%,AB2="High",100.5%)
There is no need to use SUM in this formula.
In your screenshot, "Low" etc. is in column AA and Current is in column AB, but in your formula "Low" is in AB, while Current is in Z?
What is the AND for?
Why do you multiply with 12?
*12 is for yearly amount