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!

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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