showing numbers as percentages
 

I need to create a column that shows the percentage for numbers that are in a
different column. I must be using the wrong formula because it only works if
there is data in the "number" column. I need the formula to work prior to
data being dropped into the "number" cells. As i am doing it I get an error
message in each cell DIV/0! An example of one of the forumals I used is
=B5/B10. B10 is the total i need to divide into B5, the part of the whole.

An example of how I need it to look after the numbers are dropped into the
worksheet

Number Percentage
Advanced 1 17%
Mastery 2 33%
Basic 3 50%
---------------------------------------------------
Total 6 100%

Any help is greatly appreciated.

showing numbers as percentages
 

=if(iserror(b5/b$10);0;b5/b$10)

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"MELCHAUV" escreveu:

I need to create a column that shows the percentage for numbers that are in a
different column. I must be using the wrong formula because it only works if
there is data in the "number" column. I need the formula to work prior to
data being dropped into the "number" cells. As i am doing it I get an error
message in each cell DIV/0! An example of one of the forumals I used is
=B5/B10. B10 is the total i need to divide into B5, the part of the whole.

An example of how I need it to look after the numbers are dropped into the
worksheet

Number Percentage
Advanced 1 17%
Mastery 2 33%
Basic 3 50%
---------------------------------------------------
Total 6 100%

Any help is greatly appreciated.

showing numbers as percentages
 

Try it like this:

=IF(B10=0,"",B5/B10)

You may also want to round the result:

=IF(B10=0,"",ROUND(B5/B10,0))

Format as PERCENTAGE

--
Biff
Microsoft Excel MVP


"MELCHAUV" wrote in message
...
I need to create a column that shows the percentage for numbers that are in
a
different column. I must be using the wrong formula because it only works
if
there is data in the "number" column. I need the formula to work prior to
data being dropped into the "number" cells. As i am doing it I get an
error
message in each cell DIV/0! An example of one of the forumals I used is
=B5/B10. B10 is the total i need to divide into B5, the part of the
whole.

An example of how I need it to look after the numbers are dropped into the
worksheet

Number Percentage
Advanced 1 17%
Mastery 2 33%
Basic 3 50%
---------------------------------------------------
Total 6 100%

Any help is greatly appreciated.

showing numbers as percentages
 

Ooops!

You may also want to round the result:
=IF(B10=0,"",ROUND(B5/B10,0))

Since you're working with percentages you'd want to round to 2 decimal
places:

=IF(B10=0,"",ROUND(B5/B10,2))


--
Biff
Microsoft Excel MVP


"T. Valko" wrote in message
...
Try it like this:

=IF(B10=0,"",B5/B10)

You may also want to round the result:

=IF(B10=0,"",ROUND(B5/B10,0))

Format as PERCENTAGE

--
Biff
Microsoft Excel MVP


"MELCHAUV" wrote in message
...
I need to create a column that shows the percentage for numbers that are
in a
different column. I must be using the wrong formula because it only
works if
there is data in the "number" column. I need the formula to work prior
to
data being dropped into the "number" cells. As i am doing it I get an
error
message in each cell DIV/0! An example of one of the forumals I used is
=B5/B10. B10 is the total i need to divide into B5, the part of the
whole.

An example of how I need it to look after the numbers are dropped into
the
worksheet

Number Percentage
Advanced 1 17%
Mastery 2 33%
Basic 3 50%
---------------------------------------------------
Total 6 100%

Any help is greatly appreciated.

showing numbers as percentages
 

thanks for you quick response.
says there is an error in the formula

"Marcelo" wrote:

=if(iserror(b5/b$10);0;b5/b$10)

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"MELCHAUV" escreveu:

I need to create a column that shows the percentage for numbers that are in a
different column. I must be using the wrong formula because it only works if
there is data in the "number" column. I need the formula to work prior to
data being dropped into the "number" cells. As i am doing it I get an error
message in each cell DIV/0! An example of one of the forumals I used is
=B5/B10. B10 is the total i need to divide into B5, the part of the whole.

An example of how I need it to look after the numbers are dropped into the
worksheet

Number Percentage
Advanced 1 17%
Mastery 2 33%
Basic 3 50%
---------------------------------------------------
Total 6 100%

Any help is greatly appreciated.

showing numbers as percentages
 

thanks for the quick response.
says there are too many arguments in the function.


"T. Valko" wrote:

Try it like this:

=IF(B10=0,"",B5/B10)

You may also want to round the result:

=IF(B10=0,"",ROUND(B5/B10,0))

Format as PERCENTAGE

--
Biff
Microsoft Excel MVP


"MELCHAUV" wrote in message
...
I need to create a column that shows the percentage for numbers that are in
a
different column. I must be using the wrong formula because it only works
if
there is data in the "number" column. I need the formula to work prior to
data being dropped into the "number" cells. As i am doing it I get an
error
message in each cell DIV/0! An example of one of the forumals I used is
=B5/B10. B10 is the total i need to divide into B5, the part of the
whole.

An example of how I need it to look after the numbers are dropped into the
worksheet

Number Percentage
Advanced 1 17%
Mastery 2 33%
Basic 3 50%
---------------------------------------------------
Total 6 100%

Any help is greatly appreciated.

showing numbers as percentages
 

Post the *exact* formula you tried that gives that message.

--
Biff
Microsoft Excel MVP


"MELCHAUV" wrote in message
...
thanks for the quick response.
says there are too many arguments in the function.


"T. Valko" wrote:

Try it like this:

=IF(B10=0,"",B5/B10)

You may also want to round the result:

=IF(B10=0,"",ROUND(B5/B10,0))

Format as PERCENTAGE

--
Biff
Microsoft Excel MVP


"MELCHAUV" wrote in message
...
I need to create a column that shows the percentage for numbers that are
in
a
different column. I must be using the wrong formula because it only
works
if
there is data in the "number" column. I need the formula to work prior
to
data being dropped into the "number" cells. As i am doing it I get an
error
message in each cell DIV/0! An example of one of the forumals I used
is
=B5/B10. B10 is the total i need to divide into B5, the part of the
whole.

An example of how I need it to look after the numbers are dropped into
the
worksheet

Number Percentage
Advanced 1 17%
Mastery 2 33%
Basic 3 50%
---------------------------------------------------
Total 6 100%

Any help is greatly appreciated.