Calculation always gives zero

Gianna

New Member
Joined
Nov 15, 2005
Messages
1
Hello all please help

All of my calculations are equalling 0. I might as well get a calculator out!
If i put one value, say 10 into one cell and then another value, say 3 into another cel, then multiply the two, the answer is zero.

I don't think it is the format of the cells, does anyone know if it could be the settings?

kind regards Zero
 

Some videos you may like

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

PA HS Teacher

Well-known Member
Joined
Jul 17, 2004
Messages
2,838
How are you multiplying them together? The following works fine for me.
Book3
ABCD
110330
2
3
Sheet1


In C1:
=A1*B1
 

Watch MrExcel Video

Forum statistics

Threads
1,119,002
Messages
5,575,497
Members
412,670
Latest member
Khin Zaw Htwe
Top