How do I NOT round off in a formula

[Sierra_07]

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!!

[BekkiM]

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!!
>

[Peo Sjoblom]

That not how one uses percentage, to take off 10% of 1.1 you need to use

=1.1-(1.1*10%)

that should give you a clue how to go on

Regards,

Peo Sjoblom


"Sierra_07" <Sierra_07@discussions.microsoft.com> wrote in message
news:7E98756C-A6A4-46DF-A5B7-F402DA7E1671@microsoft.com...
> 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!!
>

[Sierra_07]

Thank you, I'n new to Excel and not sure how it works, you guys really helped!

"Peo Sjoblom" wrote:

> That not how one uses percentage, to take off 10% of 1.1 you need to use
>
> =1.1-(1.1*10%)
>
> that should give you a clue how to go on
>
> Regards,
>
> Peo Sjoblom
>
>
> "Sierra_07" <Sierra_07@discussions.microsoft.com> wrote in message
> news:7E98756C-A6A4-46DF-A5B7-F402DA7E1671@microsoft.com...
> > 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!!
> >
>
>
>

[Chris Lavender]

Easier mathematically to simply say =1.1*0.9

Best rgds
Chris Lav

"Sierra_07" <Sierra07@discussions.microsoft.com> wrote in message
news:54F898B7-D3B3-4007-AC43-B5057CE968A2@microsoft.com...
> Thank you, I'n new to Excel and not sure how it works, you guys really
helped!
>
> "Peo Sjoblom" wrote:
>
> > That not how one uses percentage, to take off 10% of 1.1 you need to use
> >
> > =1.1-(1.1*10%)
> >
> > that should give you a clue how to go on
> >
> > Regards,
> >
> > Peo Sjoblom
> >
> >
> > "Sierra_07" <Sierra_07@discussions.microsoft.com> wrote in message
> > news:7E98756C-A6A4-46DF-A5B7-F402DA7E1671@microsoft.com...
> > > 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!!
> > >
> >
> >
> >