I need a blank value or zero instead of a #VALUE! error.
Since you're getting the #VALUE! error, F13 or G13 (or both) aren't
really blank. They most likely were "cleared" using the space bar, which
inserts a space character (i.e., text). The multiplication operator
chokes on text, giving the error.
Try:
=IF(COUNT(F13:G13)=2,F13*G13,0)
In article ,
Peebs wrote:
- in H13 I have the following,
=F13*G13
If F13 and G13 are blank, I get the "#VALUE1" error. I need that to be
blank or zero, but can't figure out how. Please help!
|