Forum

Excel formula based on drop down selection?
 

I am trying to create an accounting sheet on excel, I have a column with my Sale Price, A column with a drop down list on each cell with 2 payment processor selections and a column for the fees associated with that payment processor...Right now I enter in the data myself but what I want is for the cells holding the Fee amount to automatically calculate the fees of the sale price according to the payment processor selected...Anyone know How I would do this?

Thanks!

Enter this formula in the columns to autocalculate fee.

PayPal Fees =(A4)*0.04, based on 4%; where A is cell with selling price
eBay Fees =(A4)*0.10, based on 10%; where A is cell with selling price

Thanks gote, but I use propay and PayPal, if I select propay from the drop down menu I want it to reflect the fees associated with propay and the same with PayPal but I want it to calculate it in the same cell, what I choose from the menu will dictate which equation is used for the cell...is this possible?

Just the same thing, add the two together and you are in business. What % does Propay take from you. Just replace it with that of eBay and you are done; use = (Propay fees + PayPal Fees).