If cells used in formula are blank, then leave the formula cell blank

rbarnes15506

I have a =AVG formula in a column that gets its info from 2 other Columns.  If the two other cells are blank, the column with the =AVG formula populates with a #DIVIDE BY ZERO error message.

Is there a way to have the Average Column display empty if the other two are empty.

Thanks

rbarnes15506

Here is the formula I have in the Column

=AVG([L-Score]1, [O-Score]1)

Mike Wilday

=IF(OR(Isblank([L-Score]1),Isblank([O-Score]2)), "", AVG([L-Score]1, [O-Score]1) should do the trick, unless I am missing something else. Basically, if either of the scores are blank, return a blank, or run the avg formula. 

rbarnes15506

Mike:

Your formula worked like a charm, thank you so much for the help.

Ralph

Mike Wilday

You're welcome. Happy formulating!

J. Craig Williams

Mike's formula is spot on. 

This also works:

=IFERROR(AVG([L-Score]1, [O-Score]1) , "")

Craig