Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I NOT round off in a formula
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!! |
#2
|
|||
|
|||
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!! |
#3
|
|||
|
|||
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" wrote in message ... 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!! |
#4
|
|||
|
|||
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" wrote in message ... 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!! |
#5
|
|||
|
|||
Easier mathematically to simply say =1.1*0.9
Best rgds Chris Lav "Sierra_07" wrote in message ... 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" wrote in message ... 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!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Round whole numbers up and down | Excel Discussion (Misc queries) | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
If the SUM of a list is 32.2 what formula to round it up to 32.5? | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |