microsoft excel help formulas?

Question

I NEED A FORMULA TO TAKE C5 AND SUBTRACT 12.5% TO GET THE NEW AMOUNT..........WHATS THE FORMLUA PLEASE help??

Answer 1

=C5*0.875

Answer 2

http://www.ozgrid.com/Excel/increase-percent.htm

Increase/Decrease Excel Values

If you have values on an Excel Worksheet that you need to permanently increase, or decrease you can use Paste Special.

Increase/Decrease Excel Values by Percentage

Let's say you have a list of values in A1:A100 and you need to increase these values all by 15%. Here is how;

Enter the number 1.15 into any blank cell and then Copy it

Now select the range A1:A100 and go to Edit>Paste Special

Choose Values from under Paste and then Multiply under Operation and click OK.

All value will now have increased by 15%

To decrease the values by 15% you would simply Enter =1 - 0.15 in any blank cell as apposed to 1.15. This would result in 0.85 which when used in steps 2 and 3 above, would result in values being decreased by 15%


In your case you would convert 12.5% to a decimal that decimal is 12.5% = 0.125

Select the cell C5 in the feild enter =-.125

Answer 3

the second one works better (well not "better" but it is more simple), but is you want a (-) sign in there it would be

=C5-(12.5%*C5)

The first and fourth wont work - 12.5% of what? It isn't that smart.

Answer 4

make sure you type this in the formula bar in the excell work sheet it should work, @sum(C5-12.5%) usually excell will recognize that you are entering a formula and remember there is always more than one way of doing something in windows.

Answer 5

it is not. H24+a million=B24 is invalid. H24+a million can purely be an rvalue (on the right fringe of an = sign). BTW, the function you opt for is the adaptation between the specified huge type and the particular huge type.

Answer 6

=C5-.125

Answer 7

=C5-12.5%