Forum Discussion

Taylor_Watson's avatar
Taylor_Watson
Copper Contributor
Dec 02, 2019

Help with an "IF" function

I am trying to create the following...   K136 on Tab TO1 equals K125 on Tab TO1 "IF" cell B294 on Tab Cover Page B294 = YES.   K136TO1=K125TO1 IF B294COVER PAGE= YES
excel
Formulas and Functions
  • Taylor_Watson's avatar
    Taylor_Watson
    Copper Contributor
    Dec 02, 2019

    Riny_van_Eekelen 

    I entered the proposed formula but it opens a drive in my computer and gives me a #NAME?

     

    Any other suggestions?

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Dec 02, 2019

      Taylor_Watson 

      I guess it shall be

      =IF('Cover page'!B294="YES",K136=K125,"")

      just misprint in the initial formula

      • Taylor_Watson's avatar
        Taylor_Watson
        Copper Contributor
        Dec 02, 2019

        SergeiBaklan 

         

        Thanks for the response.

        Not sure why the formula will not work.

         

        After I enter formula, the ceel wants to open a file in my pc.

         

        Any other suggestions?