Hi
I need a formula to calculate different percentages for different values as below
if figure is 275 it would be 275 * 2%
but if figure is 320 it would be 300 * 2% (=6) plus 20 * 1% (=0.2) = 6.2
200-300 * 2%
from 300-350 add 1%
from 350-400 1%
500 and over *4%
Thanks
I need a formula to calculate different percentages for different values as below
if figure is 275 it would be 275 * 2%
but if figure is 320 it would be 300 * 2% (=6) plus 20 * 1% (=0.2) = 6.2
200-300 * 2%
from 300-350 add 1%
from 350-400 1%
500 and over *4%
Thanks