Forum Discussion
Taylor_Watson
Dec 02, 2019Copper Contributor
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
SergeiBaklan
Dec 02, 2019Diamond Contributor
I guess it shall be
=IF('Cover page'!B294="YES",K136=K125,"")
just misprint in the initial formula
Riny_van_Eekelen
Dec 02, 2019Platinum Contributor
Indeed. Forgot the ' '