![]() |
#1
|
|||
|
|||
![]()
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 so much for your prompt response and that worked great. Truly appreciate it!
|
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
kw01 | Excel | 1 | 06-30-2015 05:02 PM |
![]() |
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 |
![]() |
anton | Excel | 1 | 12-20-2011 03:56 AM |
![]() |
justziggy | Word | 5 | 05-23-2009 02:33 AM |