Hi
I trying to form this sum,
$1 - $999 0.5%
$1,000 - $2,999 1%
$3,000 and above 5%
But for now I can only done up to 1% portion. IF(E36>=3000,E36*5%) can't seem to work too
=IF(E36<1000,MAX(0,E36*0.5%),IF(E36>999,MIN(2999,E36*1%),IF(E36>=3000,E36*5%)))
Many Thanks
Bookmarks