RWayneH
asked on
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"),F1 1=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) ??
=IF(AND(OR(E11="4CIR",E11=
,$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) ??
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER