0

Excel IF() function not returning check box in place of True/False

Dorka Cruz

September 26, 2017 21:01

Answered

Follow

I was hoping for some assistance:

I have the following function in field I7: =IF(NF($F7,"Website")="FALSE","","√")

but instead of returning blank, it's returning √ (check mark)

What am I missing?

• Facebook
• Twitter
• LinkedIn

3 comments

• 0
  
  Heather Rowe September 28, 2017 14:53

  Probably it's the quotes around "FALSE", if you are testing against a field that returns a TRUE or FALSE result, the field is not likely to be formatted as a text field.  In that case, the TRUE / FALSE responses are like switches - is it on or off? 

  Your formula is actually saying does the word FALSE appear in the field, and what actually is appearing is a response that equates to "the switch is off".

  Try removing those quotes - the formula will probably work as expected:

  =IF(NF($F7,"Website")=FALSE,"","√")

  Edited by Heather Rowe September 28, 2017 14:53
• 0
  
  Harry Lewis September 28, 2017 14:56

  Hello Dorka.

  I assume you are using Dynamics NAV.  Is the Website field defined as a text field or as a Boolean field?

  If it is Boolean, try this:

  =IF(NF($F7,"Website"),"","√")

• 0
  
  Dorka Cruz September 28, 2017 15:06

  Heather, your suggestion worked.  Thank you so much for your assistance!