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?
2007-08-30 19:02:37 · 4 answers · asked by Kate S 2 in Computers & Internet ➔ Software
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 Pytel
2007-09-02 02:58:04 · answer #1 · answered by Frank Pytel 4 · 0⤊ 0⤋
place the cursor to F16 then type =F15-7% then press enter the result will appear in F16.
2007-08-31 02:08:11 · answer #2 · answered by Rommel R 1 · 0⤊ 1⤋
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.
2007-08-31 02:40:14 · answer #3 · answered by vbmica 7 · 0⤊ 0⤋
=f15*0.93
or
=f15*(100%-7%)
2007-08-31 02:06:56 · answer #4 · answered by Mike1942f 7 · 0⤊ 0⤋