Forum Discussion

Jaymes1995's avatar
Jaymes1995
Copper Contributor
Oct 01, 2020

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%

Resources