| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Urgent - Having trouble with decimals
Good day,
This is an urgent request... We are adding fees and taxes, but do not want numbers to round. Here's what we need: SUB-TOTAL $2,963.6300 GST $177.8178 QST $235.6086 TOTAL CA $3,377.0564 We would like the total to show $3,377.05 and not $3,377.06. What formula should we use? By the way, the GST was obtained by multiplying the first total by 0.05, the QST by multiplying GST and first total by 0.075. Any help will be greatly appreciated! Helene |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Displaying a number with different decimals depending on a condition | Excel Worksheet Functions | |||
| Conditional formatting : amount of decimals | Excel Discussion (Misc queries) | |||
| How do I change the number format for decimals from , to .? | Setting up and Configuration of Excel | |||
| How do I calculate without decimals in excel? | Excel Worksheet Functions | |||
| Urgent Urgent Urgent!!! | Excel Discussion (Misc queries) | |||
Threaded Mode
