MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Return a formula result in another cell

Posted by Lisa on December 01, 2001 2:48 AM

Can you let me know if I can return the result of a formula into another cell ie. not the one with the formula in.


Posted by Trinculo on December 01, 2001 3:14 AM

Not sure I understand what you are trying to do, but .... if your formula is in A1, put in the other cell =A1
If this is not what you wanted (probably not!), post again.

Posted by Aladin Akyurek on December 01, 2001 4:08 AM

No, you can't.

Posted by Lisa on December 01, 2001 4:32 AM

Thanks, but what I need if for the formula to put the result in a different cell. I want the end result to be cells with the formula result value in, but no other formula.

Posted by JAF on December 01, 2001 5:16 AM

This may be a stupid question, but why not simply put the formula into the cell where you want it to end up?

Posted by Lisa on December 01, 2001 8:09 AM

I'll try to explain, but it is a bit long-winded! I have a spreadsheet that monitors the days taken to respond to letters. There is a column where the user inputs the date the letter is responded to or NRR if no response is required (cell G2). The problem if that if a letter is passed to another department, the user records this in a previous cell, and the formula in G2 returns NRR automatically. So if there is not an NRR in G2 (if the letter has stayed in our department), the user enters the date they responded to the letter. The next column (lets say cell H2) subtracts the date the letter was received from the date it was responded to, and then calculates the number of working days it took to respond. The problem is that users keep deleting the formulas, so I wanted to protect the sheet - however I can't protect column G because users have to enter dates over the formula if NRR is not in the cell. I have tried conditional sum, but that didn't work - so any other ideas would be appreciated.

Posted by Drew on December 01, 2001 11:09 AM

Posted by Drew on December 01, 2001 11:18 AM

You can unprotect individual cells while the entire sheet is protected. Try this... click on column G, click format then cells, go to the protection tab, unclick "locked" then hit ok. Now you can protect the worksheet and still enter dates in column G.
Hope that helps.