Need Urgent Help, Files attached, Please assist - TIA
K KMPMBA New Member Apr 25, 2018 #1 Need Urgent Help, Files attached, Please assist - TIA Attachments sug-proj.xlsx 11.1 KB · Views: 4
chirayu Well-Known Member Apr 25, 2018 #2 this what u want? Attachments sug-proj.xlsx 13.3 KB · Views: 6
chirayu Well-Known Member Apr 25, 2018 #3 missed the double if d lol, thought u meant 10% if D. use below instead =((($B$3*$B$4)/VLOOKUP($B$5,$A$18:$B$20,2,0))*IF($B$2="D",2,1))*1.1+50
missed the double if d lol, thought u meant 10% if D. use below instead =((($B$3*$B$4)/VLOOKUP($B$5,$A$18:$B$20,2,0))*IF($B$2="D",2,1))*1.1+50
B bosco_yip Excel Ninja Apr 25, 2018 #4 Or......... =(B3*B4)/LOOKUP(B5,A18:B20)*IF(B2="D",2,1)*1.1+50 Regards Bosco