| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Result of Multiplication is comming up as zero
When I multiply C1xD1 I get an answer in E1. But when I add E1+E2 etc I get a
result of zero. All the E cells have a positive values. Any ideas? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Result of Multiplication is comming up as zero
Possibly
E1= 0.006 E2= 0.003 E1+E2 formatted to 1 decimal place displays 0.0 The underlying value is 0.009 Mike "Michael D" wrote: When I multiply C1xD1 I get an answer in E1. But when I add E1+E2 etc I get a result of zero. All the E cells have a positive values. Any ideas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| MY EXCEL SPREADSHESTS ARE COMMING UP GRAYED OUT | Excel Discussion (Misc queries) | |||
| Multiplication | Excel Worksheet Functions | |||
| multiplication | Excel Worksheet Functions | |||
| Number OK in multiplication, NOT in Sum ? | Excel Discussion (Misc queries) | |||
| result is Zero on every maths functions - sum, multiplication ... etc | Excel Worksheet Functions | |||
Linear Mode
