is this question under isblank function? if not what is it under?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i got a value in percentage in cell A1 and none in A2, another value in cell A3 and A4, then no value in cell A5. All the blank cells will eventually gonna have values, in A6 i want the average percentages of all the said cells,,, what if there are no value in each cell and i dont want to display any value in the A6 cell or i might as well put a text message on it saying there were no grade on that week.
 
Hi Leeyowh!

I interpret your question in different way:

=IF(OR(A1="",A3="",A4=""),"",(A1+A3+A4)/3)

Gives the average as long as A1, A3 and A4 have all got marks in them

=IF(AND(A1="",A3="",A4=""),"",(A1+A3+A4)/3)

Gives the average in all cases except where all of the cells A1, A3
and A4 are empty.

But if these interpretations don't cover your need, please post back.

Seasons Greetings

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
leeyowh said:
i got a value in percentage in cell A1 and none in A2, another value
Click to expand...
in cell A3 and A4, then no value in cell A5. All the blank cells will
eventually gonna have values, in A6 i want the average percentages of
all the said cells,,, what if there are no value in each cell and i
dont want to display any value in the A6 cell or i might as well put a
text message on it saying there were no grade on that week.
 
i got a value in percentage in cell A1 and none in A2, another value in cell
A3 and A4, then no value in cell A5. All the blank cells will eventually
gonna have values, in A6 i want the average percentages of all the said
cells,,, what if there are no value in each cell and i dont want to display
any value in the A6 cell or i might as well put a text message on it saying
there were no grade on that week.
Click to expand...

Please tell me you notta inglish perfesser.

If you want an adaptive average of the values in range Rng in which some or all
cells could be blank,

=IF(COUNT(Rng),AVERAGE(Rng),"no grades this week")

should work exactly as you'd like.
 
Back
Top