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 please
AC is current
AD will be potential
- so how should the formula look please
This 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?
- Hi
As per subject above
AB is the range
AC is current
AD will be potential
The formula will sit in AD, and it is the relevant % increase to the current comm column (AC)
So if Range says low I want to add 1.5% to the current to equal potential
if mid I want to add 1% to the current to equal potential
if high I want 0.5% added to current to equal potential
Hope thats clearer - added new image
Thank so much