Formula for adding percentage to number entered?

Copper 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!