Need to modify a cell to accept keyboard input and then have a formula act on that input.

[DonWFarr]

Greetings,

I have a totally functional grading spreadsheet that one person insists on a change.

What the requester would like is to have cell C4 receive a keyboard input, have a formula work on that value and then return the result to C4.

For example, the input value is 100%, the formula becomes C4=100*0.04 the result of the formula, 4% is placed back into C4.  Can this be accomplished without resulting to Visual programing?  Don

[#2]

@DonWFarr 

VBA code would be the only way to do that. It is impossible to do this within the Excel interface.

[#3]

Good spreadsheet design dictates that we do not mess with input values. It is a good idea to leave our data as is and do any processing of that data in other cells.