Return a formula result in another cell

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.

No, you can't.

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.

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

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.

Lisa,
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.
Drew