I am trying to make a spreadsheet to calculate prices for a customer, the problem I am having is applying discounts based on the amount that they purchase. For example;
A1 is # of customers A2 is price per unit
B2 is sub total
This is easy enough, my problem is I want to make a rule for B2 that states "If the # in A1 is greater than 20 than take off 1xA2"
How is this done?
Thanks for the help folks!!!
Bookmarks