Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Matrix multiplication with empty cells
Hi,
I've got matrices in my worksheet I'd like to multiply using MMULT. However, as long as some of the cells referred to are empty, I can't get a result. Excel apparently doesn't set the contents of these cells to 0 as I'd like it to. Is there a way or a setting around this? When multiplying "manually" (A1*B1 + A2*...) it works properly. Filling up the cells with zeros is not a good idea. (The table is a chess tournament table where an empty cell indicates "game not played", but a zero cell "game lost"). I'm using the German language version of Excel 97 if that matters. Regards Ingrid |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting rid of empty cells | Excel Discussion (Misc queries) | |||
How to make empty cells as zero in excel add-ins for SQL Server an | Excel Worksheet Functions | |||
CountIF cells are not empty | Excel Discussion (Misc queries) | |||
Sumproduct ... Empty Cells vs Spaces? | Excel Discussion (Misc queries) | |||
Empty Cells, Spaces, Cond Format? | Excel Discussion (Misc queries) |