| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I get my formula to stop rounding up
My spreadsheet is set-up as follows:
Cell A3 = $3324.98 Cell C10 has $938,033.00 Cell D10 is =(C10/C$23) which is 7.59% Cell C23 is the sum of column C which totals to $12,091,150.00 Cell E10 is =(D10*A3) Cell E23 is =Sum(E10:E22) The problem that I have is when the column for E10 is added up - it rounds up a penny....my answer is always a penny more than it should be....I need it to give the number without rounding.....I've tried going to Options and choosing Precision as displayed but that changes all my numbers...any ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stop % showing in outcome of formula | Excel Worksheet Functions | |||
| How do I make Excel stop rounding off my numbers that are 16 digi. | Excel Discussion (Misc queries) | |||
| Stop rounding values | Excel Worksheet Functions | |||
| Rounding to the next highest 1000 after a resulting formula | Excel Worksheet Functions | |||
| Price rounding - exception formula required | Excel Worksheet Functions | |||
Threaded Mode
