Averages / Formulas

[Kat]

I have a report in Access that calculates the average of a column of
numbers (C3) . I want to add the stipulation that if C3's totals are
zero, to not print anything in that field. The current formula is "
=Avg([C3])"
I want to add the condition that if the fields are '0' then print
nothing in the report.

The report also averages C1, C2 and C3 (=Avg([C1]+[C2]+[C3])/3). I
want to add that if C3 is blank calculate average on only C1 & C2.
Any ideas?
Thanks

[PC Datasheet]

=IIF (Sum[C3] = 0,"Nothing",Avg([C3]))

=IIF(IsNull([C3]),Avg([C1]+[C2])/2, Avg([C1]+[C2]+[C3])/3)

BTW, your formula looks to be wrong in the second question. Your calculating the
average and then taking the average of that result.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"Kat" <do********@rogers.com> wrote in message
news:b2**************************@posting.google.c om...

I have a report in Access that calculates the average of a column of
numbers (C3) . I want to add the stipulation that if C3's totals are
zero, to not print anything in that field. The current formula is "
=Avg([C3])"
I want to add the condition that if the fields are '0' then print
nothing in the report.

The report also averages C1, C2 and C3 (=Avg([C1]+[C2]+[C3])/3). I
want to add that if C3 is blank calculate average on only C1 & C2.
Any ideas?
Thanks