Percentage multiplication and subtraction

Muthukrishnan V

Active Member
Joined
May 29, 2008
Messages
269
Office Version
  1. 365
Platform
  1. Windows
Excel 2007


Col B and Col C contain numbers in numericals.



I am calculating C24*75%, minus B7, minus B11, minus B15.



For example C24=10000, B7=246, B11=543 and B15=688,
then C24*75%= 7500-246-543-688 = Answer 6023.



Kindly advise me formula.



Thanks,
 

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)
Maybe this

=C24*0.75-(B7+B11+B15)
or
=C24*0.75-B7-B11-B15
or
=C24*75/100-(B7+B11+B15)
or
=C24*75/100-B7-B11-B15
 
Upvote 0
The formula is just as you typed it: C24*75%-B7-B11-b15
 
Upvote 0
For example C24=10000, B7=246, B11=543 and B15=688,
then C24*75%= 7500-246-543-688 = Answer 6023.

Yes: =C24*75%-B7-B11-B15 is 6023. What's your question?

If those values are displayed in the cells, but that formula does not result in exactly 6023 -- or if you are not getting expected results with other values in those cells (you should have provided that example), perhaps you need to explicitly round some or all values in a prudent manner.

You might start by temporarily formatting all cells to display 15 significant digits; for example, 12 or more decimal places. That might reveal a difference between the original displayed values and their actual values.

Beyond that, any other comments might be well-intended misdirection because of the lack of details and question(s) in your posting.
 
Upvote 0

Forum statistics

Threads
1,213,565
Messages
6,114,338
Members
448,569
Latest member
Honeymonster123

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top