If someone could offer a solution on a percentage formula based on the table below I would greatly appreciate it:
if the value in cell G6 is $00.01 - $25.00, the percentage is 5.25%
if the value in cell G6 is $25.01 - $1000.00, the percentage is 2.75%
if the value in cell G6 is $1000.01 and greater, the percentage is 1.50%
For example, if I have a value of $1,255.00 in cell G6, I need to calculate the first $25.00 at 5.25%, $975 at 2.75% and the remainder of $255.00 at 1.50% added together and output a value in G7.
Doing this manually, i end up with $31.95 in cell G7 ($1.3125 + $26.8125 + $3.825)
Help
Bookmarks