hi there thank u for help
my problem is : i have many digits that comes from other cells and they have not calculated yet so
forexample i have the answer of a1,b1,c1 but i have not the answer of d1,e1,f1
but i need the average of those digits that i have them. the important is these digits are bringed from other cells so the excell doesn't show the average
<tbody>
</tbody>in need the average of these new cells in above but it shows #div/0!
how can i tell to excell : ignore those #div/0! part till they come in future then calculate them as new numbers for average function
i mean i dont need those #div/0! till the other day which i insert them in the other sells so they will bring to above chart.
did u understand what do i mean?
thank u for ur help
my problem is : i have many digits that comes from other cells and they have not calculated yet so
forexample i have the answer of a1,b1,c1 but i have not the answer of d1,e1,f1
but i need the average of those digits that i have them. the important is these digits are bringed from other cells so the excell doesn't show the average
1 | 2 | 3 | #div/0! | #div/0! |
<tbody>
</tbody>
how can i tell to excell : ignore those #div/0! part till they come in future then calculate them as new numbers for average function
i mean i dont need those #div/0! till the other day which i insert them in the other sells so they will bring to above chart.
did u understand what do i mean?
thank u for ur help