[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
2
Medium Priority
?
261 Views
Last Modified: 2013-11-07
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
Comment
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
  • Learn & ask questions
2 Comments
 
LVL 50

Accepted Solution

by:
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

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

Featured Post

Moving data to the cloud? Find out if you’re ready

Before moving to the cloud, it is important to carefully define your db needs, plan for the migration & understand prod. environment. This wp explains how to define what you need from a cloud provider, plan for the migration & what putting a cloud solution into practice entails.

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…

656 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question