I have three cells that either will have values or a number in the example below cell 2 has a value of " " or FALSE (if that helps in formula creation)
Value 1 0.9
Value 2 " "
Value 3 1.2
I need a formula that will multiply and ignore if there are any blank cells. So the end result I need is for 0.9 X 1.2. But it needs to be dynamic enough to deal with any of the values being blank, or all blank.
Value 1 0.9
Value 2 " "
Value 3 1.2
I need a formula that will multiply and ignore if there are any blank cells. So the end result I need is for 0.9 X 1.2. But it needs to be dynamic enough to deal with any of the values being blank, or all blank.