Hi,

May I ask the VBA Macro on how to apply IF condition and with corresponding computation.

Let us say:
1. I have a drop down menu in cell B2 that features Quantity of an item, cell C2 has the drop down menu of Print (service), cell D2 contains a drop down for Short bondpaper corresponding to the Size of the paper.
2. After I select those options like B2: 5 (quantity), C2: Print (type of service), D2: Short (size) it will return the value for 15 bucks.
In every 5 quantities of short bondpaper is worth 15. The value 15 will be displayed in cell D5

Thanks.