Fix #VALUE! error

C

Charles

I need a fix to a simple formula where a cell is not being recongized.
example below:
cell C1 has 88 in it with no visible formula
cell E1 - I put in formula =product(C1,2080)
returned 2080 as the solution but should have been 183040
 
G

Gordon

Charles said:
I need a fix to a simple formula where a cell is not being recongized.
example below:
cell C1 has 88 in it with no visible formula
cell E1 - I put in formula =product(C1,2080)
returned 2080 as the solution but should have been 183040
Click to expand...

Then I suspect that the data in cell C1 is text and not numeric...
 
Top