Averaging cells with formulas

petale · #1 08-10-2016, 03:43 PM

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!

xor · #2 08-10-2016, 08:13 PM

Remove the quotation marks from 100 and 94.

petale · #3 08-10-2016, 09:44 PM

Thank you so much for your prompt response and that worked great. Truly appreciate it!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Linking cells: can sub-cells move with their master-cell when sorting?	kw01	Excel	1	06-30-2015 05:02 PM
Average function not averaging	jdkoerner	Excel	11	03-02-2015 05:57 AM
Copying text range of cells to different cells adds an extra line	jpb103	Word VBA	2	07-23-2014 12:22 PM
how to transfer multiple excel cells into specific place in word document by formulas	anton	Excel	1	12-20-2011 03:56 AM
How to transfer multiple cells from excel to word by formulas	justziggy	Word	5	05-23-2009 02:33 AM