Formula for adding percentage to number entered?

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3151388%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3EFormula%20for%20adding%20percentage%20to%20number%20entered%3F%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3151388%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CP%3EIs%20there%20a%20way%20to%20set%20cells%20up%20with%20a%20formula%2Ffunction%20so%20that%20it%20does%20that%20to%20the%20number%20entered%3F%20For%20example%2C%20the%20value%20I%20need%20is%20the%20value%20I%20enter%20plus%2015%25.%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3CLINGO-LABS%20id%3D%22%5C%26quot%3Blingo-labs-3151388%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%26lt%3B%5C%2Flingo-label%26gt%3B%26lt%3B%5C%2Flingo-labs%26gt%3B%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E
New Contributor

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%.

2 Replies

@ecsummit 

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!