#1
|
|||
|
|||
Averaging cells with formulas
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! |
#2
|
|||
|
|||
Remove the quotation marks from 100 and 94.
|
#3
|
|||
|
|||
Thank you!
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 |