I have a formula that pulls stock dividends for a remote database :
"= FNBX(B30, "dividend_yield" )*$Q30".
However when there are no dividends I get the #VALUE! error. How can I make this turn to zero instead?
View best response
The formula IFERROR will help.
=IFERROR(FNBX(B30, "dividend_yield" )*$Q30,0)
When the formula FNBX gives a value, it will do as usual. However, when it returns error, 0 (as indicated after comma) will be returned.