I would like the cell with the formula to display as a value in another cell
example: Cell A1 has the formula =IF(AND(I$14>=149),"Operational Process Recommended",0), and will display "Operational Process Recommended" in A1 but
I would like "Operational Process Recommended" to be displayed in another worksheet.
If that formula is in cell A1 of Sheet1, then in your other sheet you can use this:
=Sheet1!A1
Hope this helps.
Pete
you could just reference that cell
=A1 in another cell
OR if another worksheet , include the name of the worksheet the formula is in
assuning the formula is in A1 on sheet1
and you want to show the results in sheet3 cell B3
then in sheet3 cell B3 type
=Sheet1!A1
and the results in sheet1 cell A1 will be displayed in sheet3 cell B3
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