answersLogoWhite

0

If you were comparing two cells on different sheets you would do it like this, with the sheetname and an exclamation mark preceding the cell:

=IF(Sheet1!A2=Sheet2!A2, "Same", "Different")

User Avatar

Wiki User

13y ago

What else can I help you with?

Related Questions

What notebook- like features organizes the sheets for use in Excel?

You could be referring to tabs, or the sheets themselves as being like separate pages.


What is a way of showing your data on Excel in a pictorial form?

In Excel, you use a chart. There are various ones to choose from, suited to different kinds of data.In Excel, you use a chart. There are various ones to choose from, suited to different kinds of data.In Excel, you use a chart. There are various ones to choose from, suited to different kinds of data.In Excel, you use a chart. There are various ones to choose from, suited to different kinds of data.In Excel, you use a chart. There are various ones to choose from, suited to different kinds of data.In Excel, you use a chart. There are various ones to choose from, suited to different kinds of data.In Excel, you use a chart. There are various ones to choose from, suited to different kinds of data.In Excel, you use a chart. There are various ones to choose from, suited to different kinds of data.In Excel, you use a chart. There are various ones to choose from, suited to different kinds of data.In Excel, you use a chart. There are various ones to choose from, suited to different kinds of data.In Excel, you use a chart. There are various ones to choose from, suited to different kinds of data.


How do you use Excel for typing Microsoft Word?

Excel and Microsoft word are two different programs. To ask how to you use excel for typing ms word does not make sense


What software can I use to create graphs and charts efficiently?

You can use software like Microsoft Excel, Google Sheets, or Tableau to create graphs and charts efficiently.


Why would you use a column chart in Excel?

usually for comparing two different categories with the same variables i.e. experiment involving test scores and hours of tv watched, the two columns could be two people.


Does excel allow you to cycle through the different reference types using he function 2 key?

You use the F4 key to cycle through the different reference types in Excel.


How many worksheets are present is Microsoft Excel?

Quote from the web: "According to Microsoft Excel, the number of worksheets in a workbook is "limited only by available memory." Current versions of Excel cannot use more than 1 GB of memory even if more memory is available on the system. (Excel 2007 will use as much memory as the system will give it.) In my experience, even if you could generate a well-formed workbook with 650 sheets, it is unlikely that any Excel user would be able to open it without running into Excel's memory limit. I'm impressed that you could even get to 200 sheets without a problem, honestly. "


What the maximum number of worksheets you can include in a workbook in Excel?

In Microsoft Excel, a new workbook will normally have three worksheets.


How do you use than in a question sentence?

You use it when comparing something.Do you have more than John has?You use it when comparing something.Do you have more than John has?You use it when comparing something.Do you have more than John has?You use it when comparing something.Do you have more than John has?You use it when comparing something.Do you have more than John has?You use it when comparing something.Do you have more than John has?You use it when comparing something.Do you have more than John has?You use it when comparing something.Do you have more than John has?You use it when comparing something.Do you have more than John has?You use it when comparing something.Do you have more than John has?You use it when comparing something.Do you have more than John has?


What can Excel do that word can't?

Word can only do very basic simple maths - Excel can do almost ANY type of maths! Word is just a simple text editor that can 'process' a few words into some organized format. Do not use it for DTP or financial spread sheets!!


Why are new bed sheets discolored?

In new sheets there is no perspiration and dirt from our bodies like there is on our sheets we use In new sheets there is no perspiration and dirt from our bodies like there is on our sheets we use


What are five professons that use Microsoft Excel?

Almost anyone can use Excel. Here are just five.Accountants.Bankers.Statisticians.Scientists.IT Trainers.Almost anyone can use Excel. Here are just five.Accountants.Bankers.Statisticians.Scientists.IT Trainers.Almost anyone can use Excel. Here are just five.Accountants.Bankers.Statisticians.Scientists.IT Trainers.Almost anyone can use Excel. Here are just five.Accountants.Bankers.Statisticians.Scientists.IT Trainers.Almost anyone can use Excel. Here are just five.Accountants.Bankers.Statisticians.Scientists.IT Trainers.Almost anyone can use Excel. Here are just five.Accountants.Bankers.Statisticians.Scientists.IT Trainers.Almost anyone can use Excel. Here are just five.Accountants.Bankers.Statisticians.Scientists.IT Trainers.Almost anyone can use Excel. Here are just five.Accountants.Bankers.Statisticians.Scientists.IT Trainers.Almost anyone can use Excel. Here are just five.Accountants.Bankers.Statisticians.Scientists.IT Trainers.Almost anyone can use Excel. Here are just five.Accountants.Bankers.Statisticians.Scientists.IT Trainers.Almost anyone can use Excel. Here are just five.Accountants.Bankers.Statisticians.Scientists.IT Trainers.