Gord's formula is missing a parenthesis, so you presumably didn't use his
formula? I don't know what modification you did to his formula to get the
result showing TRUE, but what I'm sure he intended to say was
=IF(AW4="","",AVERAGE(AU4,AW4))
--
David Biddulph

"Ed O'Brien" wrote in message
...
Thanks, Gord, and everyone else.

None appear to work completely... Probably something I've done.

I used your formula, Gord but all I get is the word "True" when AW4 has a
figure inserted.

Most peculiar...

Any ideas?

Ed



"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
=IF(AW4="","",Average(AU4,AW4)


Gord Dibben MS Excel MVP

On Thu, 1 Oct 2009 16:42:55 +0100, "Ed O'Brien"
wrote:

I have a cell (AW4) into which one types a figure representing a previous
period's accumulated average. (The sheet is cleared after each period and
restarted)

I have another cell (AU4) which provides a current average across
numerous
rows. (There are about 40 rows)

A third cell (AU1) shows a perpetual average from these two cells.

This formula, in cell AU1, is simple enough - =AVERAGE(AU4,AW4).

However, there are times when the user will not enter a figure in cell
AW4.
When this happens the average shown in cell AU1 is only current and not a
perpetual reading, which can be misleading, so in this event, I want AU1
to
remain blank. In other words. if nothing is entered in cell AW4 how do I
adjust the formula to prevent a figure (from only AU4) appearing in cell
AU1?

TIA for any help.

Ed