| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
stop exel from rounding
hi we have a simple formula to work out employees pay (hourly rate x hours
worked = gross amount) however currently exel is not recognising a 6 as a 6 in the final total eg 520.16 +520.10 should = 1040.26 however it is showing 1040.15 also if .11cents shows it rounds it to 0 and 520.16=520.16 the total shows 1040.11 can someone please help i have not set it up to round up or down |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I get the"Hour" command to stop rounding? | Excel Worksheet Functions | |||
| How do I stop numbers from rounding in Excel? | Excel Discussion (Misc queries) | |||
| Stop Excel Rounding Dates | Excel Discussion (Misc queries) | |||
| How do I make Excel stop rounding off my numbers that are 16 digi. | Excel Discussion (Misc queries) | |||
| Stop rounding values | Excel Worksheet Functions | |||
Threaded Mode
