|
|
|
|
|
|
|
|
|
|
|
|
|
|
Office
I am trying to show the average mark of the different scores written in 4-cell; I used the formula = average(c2:c5) the results I want C6. However, it must change the If formula, so that 0 is displayed in c6, if one of the 4 cells empty. I know not how to make it. Any help much appreciated:).... I realize that I perhaps should an average C6 result if any of the 4 cells have a score in them and that...Read More
Posted: 11 Apr 2012
Tags:
If the formula for the average which should I use
the
formula
for
average
which
should
use
|
|
|
|
|
|