VBA Macro computational

[sheen.buhay]

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.

[Catalin.B]

can you upload a sample workbook with sample data?
and details on how a selection made in cells B5 will affect the result

[sheen.buhay]

It seems I can't find the upload facility on the quick reply post. Please walk me through on how to upload the file on this thread.

Thanks.

[sheen.buhay]

Attached is the excel spreadsheet without the macro.

The sample excel provides you the ability to select appropriate options and thus provides the desired results according to the selected data.

[Catalin.B]

try this formula: (replace red values as necessary) same formula in sample attached)
how many combinations can be in Columns C and D?
If there are too many, we need another approach...
=IF(AND(C2="Xerox";D2="Short")=TRUE;B2*2;IF(AND(C2="Print";D2="Short")=TRUE;B2*3;IF(AND(C2="Xerox";D2="Long")=TRUE;B2*5;IF(AND(C2="Print";D2="Long")=TRUE;B2*4;""))))

[sheen.buhay]

Thanks Catalin for your reply however I have no problem with the conditional statement with formula. What I want to achieve is to convert those behavior to VBA Macro.

Thanks.

[Catalin.B]

you can try the sample attached...