trying to get a formula to calculate a percentage of salary if you hit different percentages of your budget. If B32@ is less than 96%, you get 0% of your salary ($g$13),

if 96% you get 3.0%,
if 97% you get 3.5%,
if 98%, you get 4%
if 99%, you get 4.5%
if 100%, you get 5%

I think I am close but missing something. Any help is greatly appreciated.


(IF(B32<0.96,0,IF(B32<.97,0.3,(b32<.98,0.35(ifb32<.99,.04,,0.05))/$G$13