You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

User profile for user: RedPickle22
RedPickle22 Author
User level: Level 1
4 points

Percentage deduction formula

Hi everyone - trying my best here to simplify paper work by using numbers. Looking to use a formula to find the following answer…. I’ll add numbers for the sake of the example. I am looking to break it down in 2 steps.


Subtotal amount 2180.00


Step 1: in cell B3, i want to identify 13% from B2 (2180.00) In theory this « unknown formula » would give me a value of 283.40 as the 13%. Which would appear in cell B3 where I would enter this formula.


step 2: I would like to add a formula in B4 where the calculation is cell B2 less B3.


thought it was easy to figure out, maybe for some, but not for me!


A (2180.00) less Cell B (in this case 283.40)


Giving me a new total in cell C of 1896.60.




Posted on Oct 12, 2022 12:57 PM

Reply
3 replies
User profile for user: Ralf-F
Ralf-F
User level: Level 4
2,717 points

Oct 12, 2022 2:41 PM in response to RedPickle22

Here the needed formulas


Based on your region the , or the ; will be used to separate the different sections of a formula. If you write one thousand as 1,000.00 then the , is used as your formula separator. If you write one thousand as 1.000,00 then the ; is used as your formula separator.


Hope this will solve your question, please let me know if this worked for you or if something in unclear.


Ralf

Reply

Percentage deduction formula

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