Circular Reference

Hello, I have another question...............I would like to have the subtract a number from the value of a cell so that number shows in the cell instead.

So if the number 12 is entered into E5. I would like for 4 to be subtraced from 12 and the cell E5 show 8 instead. Not sure if this is possible.

Thanks

I'm sure it is possible (probably require a change procedure), but it is more work than it is worth in my opinion. A spreadsheet cell works best when it is either doing data entry or calculating a formula. Trying to get a single cell to do both takes a lot more work that I believe it is worth (Remember that you have a million or more cells to work with). I would set it up so cell E5 is data entry (enter 12). Then have E6 contain the formula =E5-4. Then whatever needs to use that result can reference E6 instead of E5.