Hi,
if you are doing a sum shouldn't give you that result anyway you can use

=if(A1="",A2,if(A2="",A1,A1+A2))


"dwolf" wrote:

Formula is in cell A3 which is =A1+A2. If I don't put any numbers in A1 or A2
cell A3 displays #value! Is there a way to not have the #value! show in cell
A3?