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