2006-07-25 07:19:27 · 21 answers · asked by naomi t 1 in Science & Mathematics ➔ Mathematics
=(cell number/100)*18
OR
=cell number*0.18
2006-07-26 10:05:02 · answer #1 · answered by Anonymous · 1⤊ 0⤋
1
2017-01-20 06:32:39 · answer #2 · answered by Randy 4 · 0⤊ 0⤋
18% of 100 = 18
Therefore multiply the number by 18/100 (0.18)
In excel enter the number that you want to find the percentage for in cell A1.
in cell A2 enter the formula =A1*0.18
Iif you want you can enter 18% into the second cell (A2)
and make A3 do the maths
A3=A1*(A2/100) (the divide by 100 is dependant on whether the cell is set up as a percentage!!)
This will mean that you can modify the percentage easily.
2006-07-29 03:13:23 · answer #3 · answered by Mark G 2 · 0⤊ 0⤋
First find the decimal equivalent of the 18%
18% = 18/100 = 0.18
To find decimal equivalent divice 18 by 100.
0.18 is the dexomal equivalent
Multiply the number by 0.18 for the answer
2006-07-25 09:16:01 · answer #4 · answered by SAMUEL D 7 · 0⤊ 0⤋
I am cutting+pasting one of my previous replies because the question is almost identical.
Homework!
If you have been asked to do this but don't know how then you should ask your teacher. Understanding the principles will do you far more good than just asking a random bunch of strangers for an answer. This really is a simple question so you should be trying to understand what % means instead of just asking for an answer.
As a person totally unqualified as a teacher I will do my best to explain.
% means hundredths, 1% is one hundrendth, 200% is double.
18% of something is 18/100 ths of it so the answer to your question is
18*number/100
But seriously if you don't know how to do this then you should ask a teacher for clarification.
2006-07-27 12:42:57 · answer #5 · answered by m.paley 3 · 0⤊ 0⤋
SUM = B2/100*18
The formula would allow you to use the number in cell B2 to be divided by 100 then multiply by 18 to give you 18% of the number in B2.
2006-07-26 08:07:36 · answer #6 · answered by dragoondf 2 · 0⤊ 0⤋
=(18/100)*X, where x is the number
2006-07-25 07:23:39 · answer #7 · answered by Pistu 2 · 0⤊ 0⤋
= no*18%
2006-07-25 07:22:53 · answer #8 · answered by a_ebnlhaitham 6 · 0⤊ 0⤋
= (number/100)*18
2006-07-25 07:24:43 · answer #9 · answered by MRSA+ 3 · 0⤊ 0⤋
= 18*[the number you want to find 18% of]
2006-07-25 07:21:18 · answer #10 · answered by brian 2 · 0⤊ 0⤋
=0.18*numberinquestion Or, if it's a number in a particular cell and you would like to multiply that one by 18%, it would be =(A2)0.18 or whatever cell it's in.
2006-07-25 07:23:17 · answer #11 · answered by gilgamesh 6 · 0⤊ 0⤋