Forum Discussion
Jaymes1995
Oct 01, 2020Copper Contributor
Need help with formula
Hello.
I am sure this is a simple problem. Formula to multiply part of the cell value, based on range, by a different %. Please see a simple example below.
Cell value: $100,000
Column A
Row 1: If cell value is between $0 to 10,000, 8%.
Row 2: If cell value is between $10,001 to 15,000, 10%.
Row 3: If cell value is $15,0001 to 20,000, 15%.
Row 4: If cell value is $20,001 to 25,000, 20%
3 Replies
- SergeiBaklanDiamond Contributor
With such helper range
formula could be
=SUMPRODUCT((IF($A$2>$E$2:$E$5,$E$2:$E$5,$A$2)-$D$2:$D$5+1)*($A$2>$D$2:$D$5)*$F$2:$F$5)- Jaymes1995Copper Contributor
- SergeiBaklanDiamond Contributor
Jaymes1995 , you are welcome