Hi there!
I want to set up two pages.
The first is with a set of formulae.
On the second, I want "True" to appear in the corresponding cell on page 2, if a certain value appears in that particular cell on page 1, in this case '-1'.
Please help me with the formulae for page 2.
For example, "-1" appears in cell D52 on page 1, then I want "True" to appear on cell D52, page 2.
Many thanks in advance!
Paul
I'm assuming by PAGE you mean sheet
in sheet2
put
=sheet1!D52 = -1
should return a TRUE or FALSE
However a sample spreadsheet attached , see yellow banner at top of thread would help
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks