Hi friends,
In my workbook cell G3 contains the formula =PRODUCT(D3*F3) untill I put values into cells D3 and F3 the #VALUE! is entered. Is there any way to make this disappear and perhaps have $0.00 instead? The G3 column is formatted for currency. Thanks for any suggestions.
David
perhaps =PRODUCT(D3,F3) rather than =PRODUCT(D3*F3) ?
Rule 1: Never merge cells
Rule 2: See rule 1
"Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".
One way
=IF(ISERROR(PRODUCT(D3*F3)),0,PRODUCT(D3*F3))
VBA Noob
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
You are the best! Thank you.
David
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks