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?
- Sorry AB is the range
AC is current
AD will be potential
- so how should the formula look pleaseThis is extremely confusing - you have now stated three different sets of columns.
Let's start from scratch. What is the amount you want to add 1.5%, 1% or 0.5% to?
- *12 is for yearly amount
