Adding a percentage to a Price

I need to add a percentage to a dollar amount. Would like a formula to do so. It seems so simple, yet I'm about to lose my mind over this. Any help would be appreciated. Thank you!!



For example: add 30% to 25.00.

MacBook Air 13″, macOS 14.6

Posted on Aug 27, 2024 6:42 AM

Reply
Question marked as Top-ranking reply

Posted on Aug 27, 2024 10:11 AM

The formula to add 30% would like this:

A1 * (1 + 0.30)


Where:

  • A1 is the cell containing the value to increase, 25.00 in your example;
  • “0.30” is 30% (or 30/100.)
3 replies

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Adding a percentage to a Price

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.