Simple Sheet Formula Question

[stuartgb100]

=D25*V25 returns #VALUE! if D25 is empty/blank
How to exclude similar blank cells please ?

 

[Joe4]

If it were TRULY blank, it would return 0.
It only returns that if there is a non-numeric entry in there, like a space (note that a space is NOT the same as blank/empty!).

If you cannot get rid of the spaces, you could do this to handle the errors:
=IFERROR(D25*V2,"")
to return nothing in those cases, or
=IFERROR(D25*V2,0)
to return a zero in those cases.

 

[stuartgb100]

Many thanks.

 

[Joe4]

You are welcome.

 

[shaowu459]

Here is another solution for your reference:
=N(D25)*V25