Formula help. IF(AND(OR(

In the following formula how do I point the value to another sheet tab?

=IF(AND(OR(E11="4CIR",E11="3CIR"),F11=1066.8),$M$3,0)

,$M$3,0)  currently points to the same sheet tab the formula is in.

How would I rewrite the formula so the target value is?  say  Sheet2$M$3,0)  ??
RWayneHAsked:
Who is Participating?
 
barry houdiniConnect With a Mentor Commented:
Just use the sheet name followed by !, i.e.

=IF(AND(OR(E11="4CIR",E11="3CIR"),F11=1066.8),Sheet2!$M$3,0)

If the sheet name has any spaces (or consists of only numbers) then you also need single quotes around it like this - if sheet was called sheet two

=IF(AND(OR(E11="4CIR",E11="3CIR"),F11=1066.8),'sheet two'!$M$3,0)

regards, barry
0
 
RWayneHAuthor Commented:
EXCELent!!  Thanks. -R-
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.