Percentage deduction formula

Question

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

Answer 1

jaxjason

Level 5

5,063 points

Oct 13, 2022 12:58 PM in response to RedPickle22

here is a guide for using numbers to enter formulas like yours, it sounds like you know the math, just need to learn how to do it in the program.

Calculate values using data in table cells in Numbers on Mac - Apple Support

Jason

Reply

Answer 2

Ralf-F

Level 4

2,741 points

Oct 12, 2022 2:44 PM in response to Ralf-F

For 13% you can use 0.13 or 13%

You type * and Numbers will set it to x in the formula.

Ralf

Reply

Answer 3

Ralf-F

Level 4

2,741 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