none
Help with IF formula

    Question

  • I am trying this in B13:

    IF(B11=0,"",)=B4

    to leave B13 blank unless B11 is filled in.  The answer I am getting is False.  Any suggestions?

    Thursday, March 22, 2012 3:55 AM

Answers

  • Hi,

    First, if sheet2!$C$3 is blank, then B11 in sheet3 will be 0.

    So use this formula in B11 in sheet3:=IF(Sheet2!$C$3="","",Sheet2!$C$3)

    Then in B13, use this formula: =IF(B11="","",IF(B11="","",)=B4)

    In your formula (IF(B11=0,"",)=B4), it will always to judge whether the value of "IF(B11=0,"",)=" is equal to B4. And the result will always be TRUE or False.

    So my formular is to judge whether the B11 is blank, then leave B13 blank, otherwise, to judge whether the value of "IF(B11=0,"",)=" is equal to B4.

    And why I change "B11=0" to " B11="" " is because in case the C3 in sheet2 is 0, then the result will be incorrect.

    Hope this will help you!


    Jaynet Zhang

    TechNet Community Support

    Friday, March 23, 2012 8:10 AM
    Moderator

All replies

  • =IF(B11="","",B4)

    Ed Ferrero
    www.edferrero.com

    Thursday, March 22, 2012 4:21 AM
    Answerer
  • In B11, I have the following:

    =Sheet2!$C$3

    Even when nothing is entered in cell C3 on Sheet 2, the number from B4 is showing up.  I would like it to be blank until I fill in C3 on Sheet 2.

    Thursday, March 22, 2012 11:50 AM
  • Hello,

    Try this

    =IF(B11="","",B13)

    Thursday, March 22, 2012 12:12 PM
  • Hello,

    Try this

    =IF(B11="","",B13)

    Unfortunately, that doesn't work.

    Thursday, March 22, 2012 12:19 PM
  • Hi

    As B11 is "=Sheet2!$C$3" then it will show 0 when Sheet2 C3 is empty.

    =IF(B11="","",B13) is checking for nothing not a 0

    You could target the cell controlling this directly as below

    =IF(Sheet2!$C$3="","",B4)

    This will show nothing if C3 on sheet 2 is empty and the contents of B4 when it is not.

    Hope this helps


    G North MCT



    • Edited by G North Thursday, March 22, 2012 1:24 PM
    Thursday, March 22, 2012 1:23 PM
  • Hi,

    First, if sheet2!$C$3 is blank, then B11 in sheet3 will be 0.

    So use this formula in B11 in sheet3:=IF(Sheet2!$C$3="","",Sheet2!$C$3)

    Then in B13, use this formula: =IF(B11="","",IF(B11="","",)=B4)

    In your formula (IF(B11=0,"",)=B4), it will always to judge whether the value of "IF(B11=0,"",)=" is equal to B4. And the result will always be TRUE or False.

    So my formular is to judge whether the B11 is blank, then leave B13 blank, otherwise, to judge whether the value of "IF(B11=0,"",)=" is equal to B4.

    And why I change "B11=0" to " B11="" " is because in case the C3 in sheet2 is 0, then the result will be incorrect.

    Hope this will help you!


    Jaynet Zhang

    TechNet Community Support

    Friday, March 23, 2012 8:10 AM
    Moderator