I have a sum of numbers determining priority of workflow in Column E(E2:E6). Now in Column F(F2:F6) there will be three options to enter for additional urgency, BC= weighted at 70%, BP= weighted at 30%, N/A= weighted at 0%.

Can you, with one formula, properly determine the prioritized urgency in cells F2:F6?
Prioritization Model.xls