Adding 1% to a Value in Excel: Formula for Incrementing by Percentage

Xklocek 28248 1

ADVERTISEMENT

Treść została przetłumaczona

»

Zobacz oryginalną wersję tematu

#1 3451153 16 Jan 2007 21:49

Xklocek Xklocek

Level 11

» |

Post #1
3451153 16 Jan 2007 21:49

Hello

example:
I have "2000" in the A1 cell
in A2 cell "= a1 + 1%"
result "2000.01"

how do I add 1% hehee (I laugh and want to laugh at myself)
ADVERTISEMENT
Helpful post

#2 3451354 16 Jan 2007 22:16

rado_ rado_

Level 22

» | Positive voted Helpful post? (+8)

Helpful post
Post #2
3451354 16 Jan 2007 22:16

in cell a2 you must enter = (A1 * 0,01) + A1
Create an account, log in and become active in a forum and ads will not appear. You will receive points by participating in discussions.
Join this discussion.

Install the application

Didn't find an answer? Ask Artificial Intelligence

*I agree to send the question to OpenAI, Anthropic PBC, Perplexity AI, Inc., Kagi Inc., Google LLC - owners of language models in order to prepare the best response. The companies may monitor and log information entered into the form.

*I agree to publicly display my question and answer. The question and answer will be publicly available to everyone. The process may take a few minutes. Upon completion, you will be redirected to the page with the answer.

Wait...(2min)

Report a violation of the law

ADVERTISEMENT