View Single Post
  #2   Report Post  
BekkiM
 
Posts: n/a
Default

Are you literally subtracting your percentages? If so, that would explain
why you're getting .90 because 1.1 - 0.1 - 0.05 - 0.05 does actually equal
0.90.

The formula you want is:
A B C D
1) 1.1 10% 5% 5%

=((A1*(1-B1))*(1-C1))*(1-D1)

which will give you 0.893475, or, rounding to 2 digits, 0.89


"Sierra_07" wrote:

In my worksheet, I have a regular price for general customers and then
another for the bigger buyers. How do I not round off in my formula?

Example:
=A1-10%-5%-5%
OR
=1.1-10%-5%-5% should equal .89 not .90 which I am getting.

I have to do it this way because I can't just take off 20%(i get a totally
differnet #). Please help!!