SOLVED

I want "#VALUE!" error to become zero

Iron Contributor

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?

1 Reply
best response confirmed by Greg Bonaparte (Iron Contributor)
Solution

@Greg Bonaparte 

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 best response

Accepted Solutions
best response confirmed by Greg Bonaparte (Iron Contributor)
Solution

@Greg Bonaparte 

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. 

 

 

View solution in original post