Either percentage or dollar discount formula

  • Thread starter Thread starter KHiggins2008
  • Start date Start date
K

KHiggins2008

Would like to have the option to discount a list of sales items by either
plugging in a discount OR a dollar amount on the same row.
 
In order to make this work, you need to either tell excel what you
want to do (i.e. % or $) or make an assumption about the data.

this assumes the following:
a1 has the sales amount
b2: If you're entering a % it will be less than 1 (i.e. .25 or 25%).
if the number is > then 1 it assumes that you're subtracting $
c2 has this formula =IF(B1<1,A1-A1*B1,A1-B1)
 
Thank you, but I think I worded the question wrong - what I am trying to do
is give a sales rep the option to either put in a % discount, or allow them
to enter a FINAL price without them having to calculate. For example, an
item listed at $20,000, and they want the final price to be $17,500. How can
I let them either say "I want a 20% discount, or I just want the price to
"end up" being $17,500. Thanks again.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional PRODUCT or SUM 9
If - then help. 6
filter for round numbers 2
calculate percentage?? 2
Percentage Help 1
Simple Question, Calculating Discounts 3
formula 1
Conditional format; if statement 3

Back
Top