Fill In The Cells With #n/a

A B C
01/01/04 36.83
02/01/04 38.93 How can I fill in these spaces with #N/A in col. C
03/01/04 37.78 without erasing the cels that have the average.
04/01/04 39.96 So I can make the graph.
05/01/04 35.35
06/01/04 34.82
07/01/04 38.93 37.51
08/01/04 30.31 Undernead is the formula to calc
09/01/04 35.64 the average of the week
10/01/04 34.57
11/01/04 38.14 =SI(JOURSEM(A11)=4;MOYENNE(B5:B11);"")
12/01/04 37.88
13/01/04 34.49
14/01/04 38.27 35.61
15/01/04 35.89
16/01/04 34.11
17/01/04 34.25
18/01/04 36.64
19/01/04 34.91
20/01/04 35.48
21/01/04 36.83 35.44
22/01/04 33.41
23/01/04 33.24
24/01/04 37.57
25/01/04 38.42
26/01/04 23.29
27/01/04 29.44

Hi

Try....
=SI(JOURSEM(A11)=4;MOYENNE(B5:B11);"#N/A")

HTH
JG

but I stiil get the 0 values when i try to do the graphic, shouldnt it remove all this values by using #n/a

Hi
I don't know, I'm not an expert. Maybe someone else could help you.

JG