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 zero instead?
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.
1 Reply
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.