#value for multiplication when referenced cells contain formulas

[carrollkm]

Hi all,

In "Athlete 1" Worksheet

Column AK under "VL"

Each box contains a formula to multiply and add together some of the cells contained to the left.

The problem is there are formulas in the cells to the left that, when left blank, yield a #VALUE error. Is there a way to correct this? It is beyond my scope of understanding unfortunately.

Thank you for any help you can provide me with! It is appreciated more than you know.

-Kevinsample.xlsx

[MarvinP]

Hi Carrol,

This looks like a job for the IfError() function. Try in AK7:

=IfError(((N7*O7+P7*Q7+R7*S7+T7*U7+V7*W7+X7*Y7+Z7*AA7+AB7*AC7+AD7*AE7+AF7*AG7)/2.2046),"")

[carrollkm]

Thank you for your quick reply!

The problem I am having is that I want the cells that contain values to be multiplied and summed up. When using iferror() it will only display as a blank cell. Do you know of a way to do this?

[MarvinP]

OK Kevin,

Put zero in all those blank places so your formulas don't give an error. If you really need them to look like blanks then do a conditional formatting of those cells. If they equal zero make the font and background white.

That way your formula will work and still look like a blank when they are zero.