Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Weird Multiplication!
I've just entered into Excel:
=77.1*850 and the answer I get is 100,000, when I clearly shoudl be getting 65,535. What's happened? Even if I enter: 77.1 in cell A1 (which Excel stores as 77.1 in number format) 850 in cell A2 ( "" "" ) And then, in A3, enter: =A1*A2 I still get 100,000!!!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiplication | Excel Worksheet Functions | |||
multiplication | Excel Worksheet Functions | |||
Matrix Multiplication | Excel Worksheet Functions | |||
matrix multiplication | Excel Worksheet Functions | |||
Multiplication in one cell | Excel Discussion (Misc queries) |