Solved

Formula help.  IF(AND(OR(

Posted on 2013-11-06
2
256 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 500 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

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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.
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

735 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