Percentage multiplication and subtraction

[Muthukrishnan V]

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,

 

[Sahak]

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

 

[kweaver]

The formula is just as you typed it: C24*75%-B7-B11-b15

 

[joeu2004]

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.