Average Formula to display blank cell if named range is blank
you can do an if(iserror(formula),"",formula
--
-John
Please rate when your question is answered to help us and others know what
is helpful.
"Rachael F" wrote:
Hello
I have looked through the Excel posts but could not find an answerto the
following question. I would be grateful for any help.
I would like a formula that will display the average of columns A:C in
column D. This works fine if there are values in columns A:C, eg
5.0+5.0+7.0=5.6
If, however, the cells in A:C are blank, #DIV/0! is displayed.
A B C D
5.0 5.0 7.0 5.6
4.5 4.5 5.0 4.6
#DIV/0!
I would like column D to be blank if A:C are blank
& if values are displayed in A:C for the average value to be displayed in
column D.
I am using Excel 2000.
Many thanks.
Rachael
|