Either percentage or dollar discount formula
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)
On Jun 12, 8:54 am, KHiggins2008
wrote:
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.
|