Forum Discussion
Formula for adding percentage to number entered?
Is there a way to set cells up with a formula/function so that it does that to the number entered? For example, the value I need is the value I enter plus 15%.
You should not do that in the same cell, it can easily lead to errors. It's better to use a formula such as
=cell*115% in another cell.
But if you really want it, it would require VBA, which has the nasty side-effect of disabling Undo...
Got it. Thanks for your response!