Hi!
I would like to use a formula in Numbers that will:
Take a total amount: $120.00.
minus a deductible: $100,
then multiply by a certain percentage: 10%
For example:
$120.00 - $100.00 x 10%
so I just need to calculate the percentage on any amount over $100.00.
I will be using the same equations to calculate different amounts, so I guess I can use different amounts in the one formula.
Any help would be greatly appreciated!
Thank you,
Mary
MaryKay456 wrote:
I will be using the same equations to calculate different amounts, so I guess I can use different amounts in the one formula.
Spreadsheets are really good at this kind of thing. You can set up a formula once, copy it down a column, and try different combinations of "inputs". For example, you could do something like this:
The formula in D2 would be typed in like this:
=(A2−B2)*C2
Then why you've got it working in D2, hover over the bottom edge of the cell and drag the yellow dot down. Or select D2, command-c to copy, select the rest of the cells in the column, and command-v to paste.
If you don't like the minus -5, etc., when the amount is less than 100 then you can get a little fancier if you want and use this:
=MAX(0,(A2−B2)*C2)
SG
MaryKay456 wrote:
I will be using the same equations to calculate different amounts, so I guess I can use different amounts in the one formula.
Spreadsheets are really good at this kind of thing. You can set up a formula once, copy it down a column, and try different combinations of "inputs". For example, you could do something like this:
The formula in D2 would be typed in like this:
=(A2−B2)*C2
Then why you've got it working in D2, hover over the bottom edge of the cell and drag the yellow dot down. Or select D2, command-c to copy, select the rest of the cells in the column, and command-v to paste.
If you don't like the minus -5, etc., when the amount is less than 100 then you can get a little fancier if you want and use this:
=MAX(0,(A2−B2)*C2)
SG
Thank you, SGIII!
It worked!!
Thank you for the easy to understand reply!
Mary
iOS Numbers
