# Calculated column w/ IF condition not showing the false value

Copper Contributor

# Calculated column w/ IF condition not showing the false value

Good day everyone,

I'm trying to create a calculated money column which looks another column to find and specific text and if is TRUE is gonna be the value of another money column already created and if FALSE it must be \$0.00.

Here the query: =IF(FIND("B11",NCF),[Col1],0)

When false is throwing me #¡VALOR!

4 Replies

# Re: Calculated column w/ IF condition not showing the false value

Hi @Byking23 - I just got this to work in my dev environment:

=IF(Category="NCF",[Amount],"\$0.00")

# Re: Calculated column w/ IF condition not showing the false value

Hi Kelly,

The thing here is that is a text field and it doesn't have the specific text i compared. That's why i place the fuction FIND because the text has B1100005486 and im tryna find the B11 in the entire text as the fuction CONTAINS. If the item contains B11 in this field it must have the value of a column im gonna set, if no \$0.00.

Got it?

# Re: Calculated column w/ IF condition not showing the false value

If the "false result" is throwing an error, then you're using wrong a data type for your false value, corresponding to your target column.
0 is a number (col), "0" is a string/text.

# Re: Calculated column w/ IF condition not showing the false value

@Byking23 Try using formula like this:

``=IF(ISERROR(FIND("B11",[NCF])),0,[Col1])``

Output

Note:

1. Sometimes comma( , ) does not work in formula (it is based on language or regional settings on your site). So in that case use semicolon( ; ) instead of comma( , ).
2. Use correct display name of your SharePoint columns in above formula.
3. Wrap column names inside [] if your column name has space in it. For example: [My Column Name].

Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.