Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Multiplication of cells returns value error
Hello I am new here and new to excel so I hope that I am posting this is the right place and explain it correctly.
I need to create the following a1*d1 however in some of the rows A may be empty and this returns a #value error in the f column which will be summed and prevents a total where rows contained the value error. I do not want the spread sheet user to have to type 0 in the a fields each time. So it is desirable that if A is empty I don't get a value error |
#2
|
|||
|
|||
Quote:
__________________
Asobi Wa Owari Da |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Simple multiplication of 2 cells = wrong product | Excel Discussion (Misc queries) | |||
Multiplication error: Off by .03 | Excel Discussion (Misc queries) | |||
INDEX formula returns #REF! error for ranges larger than two cells | Excel Worksheet Functions | |||
Multiplication error | Excel Discussion (Misc queries) | |||
Matrix multiplication with empty cells | Excel Worksheet Functions |