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