I have a row of cells across 10 columns (B17:K17) that each contain a formula. I am trying to average the "results" but get a #DIV/O error.

Example:
In Cell B17, my formula reads: =IF (B15=1,"100", IF (B15=0,"94")). When a value of 1 or 0 is entered in B15, the result displays in B17, e.g., 100 or 94. I have this formula in C17, D17, E17, F17,etc.

When using the Average function (=average (B17:K17), I get the #DIV/0 error. When trying the averagea function, I just get "0".

Is there a way to average the formula results without using VBA?

Thanks for your help!