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