Using Excel to bulk update with surcharge?

I currently use Excel to do bulk updates, usually basic updates, but I need to add a dropdown menu to multiple products (which I know how to do)…but I also need to add a surcharge, how would I do this?

Example: I’m adding a drop down (Yes or No) to multiple products, but for the Yes I need to add a + $5 surcharge.

I’m not quite sure I know how to add a surcharge in bulk for specific drop down answer…

Any help would be appreciated, thank you :slight_smile: