showing numbers as percentages

[MELCHAUV]

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%

 

[Marcelo]

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

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



"MELCHAUV" escreveu:

 

[T. Valko]

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

 

[T. Valko]

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))

 

[MELCHAUV]

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

 

[MELCHAUV]

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

 

[T. Valko]

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