[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
Solved

# Formula help.  IF(AND(OR(

Posted on 2013-11-06
Medium Priority
261 Views
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)  ??
0
Question by:RWayneH
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points

LVL 50

Accepted Solution

barry houdini earned 2000 total points
ID: 39628744
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

Author Closing Comment

ID: 39630051
EXCELent!!  Thanks. -R-
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
###### Suggested Courses
Course of the Month13 days, 22 hours left to enroll