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%)
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 muchIn 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%)