View Full Version : Someone must Know??
BBOPPIN
July 26th, 2006, 01:31 PM
Does anybody know if you can put a formula (ex. =SUM(B6+B8) ) into one cell (say B12) and have the answer to that formula come up in a different cell, say (C11)?
rnman
July 26th, 2006, 01:57 PM
doesn't c11=b12 in the c11 cell work?
chryssi2001
July 26th, 2006, 03:05 PM
Does anybody know if you can put a formula (ex. =SUM(B6+B8) ) into one cell (say B12) and have the answer to that formula come up in a different cell, say (C11)?
Go at C11 cell click (sum b6+b8) enter and you have it. If you have it that formula in B12 in C11 write =b12 and your formula comes there.
BBOPPIN
July 27th, 2006, 04:15 AM
Thank you very much. I have these big formulas written into a few cells and if you accidently type a number into those cells, you loose your formula.
Thanks again
oracle128
July 27th, 2006, 08:15 AM
If you select all the cells you want the user to be able to change, then go Format->Cells->Protection, and untick the "Locked" checkbox. OK. Then go to Tools->Protection->Protect Sheet. You don't need to enter a password, just OK. All the cells where you unticked the Locked property can be edited, but the others (the ones with the formulas in them) can't. An error message will come up if you try editing a Locked cell while it's still protected, and you won't be able to edit those cells without going Tools->Protection->Unprotect Sheet.