Result of Multiplication is comming up as zero

  • Thread starter Thread starter Michael D
  • Start date Start date
M

Michael D

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?
 
Possibly

E1= 0.006
E2= 0.003

E1+E2 formatted to 1 decimal place displays 0.0
The underlying value is 0.009

Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top