Google Sheets Problem, Please Help!

[Arcynth]

I am currently trying to find a way to set a protected 'default' cell value on Google sheets so that I can have a formula 'locked' in the cell. I need this to work in such a way that if someone was to edit the cell and then delete what they had entered it would revert back to the protected 'default' value. This is because I need a cell to do multiple jobs acting upon other cells with said formula or sometimes being a cell data is input into to effect other cells.

My other idea was to get a formula to output to a different cell than the one that it is entered into, but I don't know if this is possible either.
EG. =IF(A1=1,B1=2,B1=1) (this formula is typed in C1)

 

If this is the wrong place to post this question then please let me know, but I am running out of ideas as to how to get this to work now!

 

Thanks in advance.

[DEDRICK]

You could use 3 cells, one user defined, one predefined, one formula.  Then you would use an IF statement determine which value to use in formulas.

 

Say A1 is Default, B1 is User. C1 would be =IF(B1="",A1,B1). All formulas would reference C1.  

 

Another choice would be to incorporate the If statement into the final calculation, this would save you 1-2 cells Cell=IF(A1="",defaultValue,A1)*B1