Forum Discussion
Solved
I want "#VALUE!" error to become zero
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 z...
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.
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.