Help with an "IF" function

Question

I am trying to create the following...&nbsp;K136 on Tab TO1 equals K125 on Tab TO1 "IF" cell B294 on Tab Cover Page B294 = YES.&nbsp;K136TO1=K125TO1 IF B294COVER PAGE= YES

riny_van_eekelen · Answer

Taylor_Watson&nbsp;Try this:=IF(Cover page!B294="YES",K136=K125,"")&nbsp;

taylor_watson · Answer

Riny_van_Eekelen&nbsp;I entered the proposed formula but it opens a drive in my computer and gives me a #NAME?&nbsp;Any other suggestions?

sergeibaklan · Answer

Taylor_Watson&nbsp;
I guess it shall be
=IF('Cover page'!B294="YES",K136=K125,"")
just misprint in the initial formula

riny_van_eekelen · Answer

SergeiBaklan&nbsp;Indeed. Forgot the ' '

taylor_watson · Answer

SergeiBaklan&nbsp;&nbsp;Thanks for the response.Not sure why the formula will not work.&nbsp;After I enter formula, the ceel wants to open a file in my pc.&nbsp;Any other suggestions?

Forum Discussion

Help with an "IF" function

8 Replies