How to create a formala in one sheet for a cell in another sheet?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to set up a formula in one sheet to appertain to a cell in another
sheet of the same workbook. is this possible if so how?

Ant help would be great thanks
 
=IF(Sheet2!A1>0,1,0)

as an example, easiest way is actually to use the mouse and select the
cell(s) on the other sheet, that way sheet names will be inserted
automatically
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Set up a formala to refer to a cell in a different sheet 4
Excel, assign cells in multiple worksheets from one sheet 1
Count the columns from one sheet and paste it in another sheet 0
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Dependent drop down dynamic range formula, off sheet. 7
Vlookup and return sheet name also 2
Daily Time Sheets with Rounding 1
using the =page! feature to transpose a row to column 0

Back
Top