May 04 2019 05:05 PM
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?
May 04 2019 06:20 PM
SolutionThe 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.
May 04 2019 06:20 PM
SolutionThe 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.