Quote Originally Posted by Mike_Dean
Oooopss that part of the formula would help..!!

IF AE16 = 1, then A20*0.27+$B$5
IF AE16 = 2 then A20*0.25+$B$5
IF AE16 = 3 then A20*0.22+$B$5
Another option 
=a20*lookup(ae16,{1,2,3},{.27,.25,.22})+$B$5