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?