Can anyone help with the following: -

I have data in cells A2 and A3, in another cell (A10) I need a formula so
that

If there are no values in A2 or A3 the value shown in A10 will be zero and
if there are values in both A2 and A3, A10 will show the average of A2 and
A3 (as in (A2+A3)/2) but if there is a value in A2 and no value in A3 (or
visa versa), A10 shows the value in A2 (or A3) without entering the average
of the two cells.

Regards,
Brendan