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!
The complete step-by-step guide to get back to selling today!
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?
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).
__________________
To Every End, There Is A New Beginning!
The Following User Says Thank You to GoteBay For This Useful Post: