How to take a figure in excel and minus 7%?

I've racked my brain and the internet trying to do this. I am adding cells F2 through to F13, that equals F15. I want to take the number from F15 and minus 7% to equal F16.


Can anyone help?How to take a figure in excel and minus 7%?
Depends on the value of F16. Might be you need to determine what the value of F15 to F16 is in a percentage format.





God Bless





Frank PytelHow to take a figure in excel and minus 7%?
=f15*0.93


or


=f15*(100%-7%)
Although the first answer is correct, it seems silly to type 100%-7% in the formula when you could more easily type 93%





and as suggested .93





The second formula does not work and is not correct.





Typicallly I would use the following since it seems to be more easily under stood as to what we are doing.





=a15-(a15*7%)





This also works well when you are working with numbers like 7.0638%





Choice is yours now except the second one, which gets a thumbs down.
place the cursor to F16 then type =F15-7% then press enter the result will appear in F16.