Locking a Formula into a Cell

[jtsanabria]

So I currently have a range of cells that have formulas within them. The formulas are basic if statements: G6=IF(F6="n","N/A",""). Note: F6 will only be either Y or N. So in a sense, if the user chooses N in F6, then G6=N/A and otherwise, G6 is not populated with any text. However, based on the application of the worksheet, if F6 is "y", G6 will be changed to a value that the user will input. How can i make it so that if the user is messing around in those cells, the formula in G6 will not be deleted. Can it be "put into the background"?

[Jakobshavn]

1. Enter the formula in G6
2. Lock G6
3. Protect the worksheet.

[adyteo]

un-lock (format cells --> protection tab) all cells then lock G6 and then protect the sheet

[jtsanabria]

Right, but If the user inputs "Y", G6 should be able to be changed to a numerical value. For instance, if the user chooses N for F6, the cell G6 should read "N/A" and if the user chooses Y for cell F6, no value should automatically be populated into G6. Rather, if Y is chosen, the user should be able to change the cell value to a numerical value of their choice. However, lets say they choose Y, change G6 to 3, delete the 3, and then change F6 back to N - I want the value of G6 to then read N/A or in otherwords, the formula remain unchanged

[Jakobshavn]

Then I would use a third cell, say A1:

=IF(F6="N","N/A",IF(A1="","",A1))

1. If F6 is N, then G6 reads N/A
2. If F6 is Y, then G6 can read the value in A1