| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| whole Numbers entered; percentages displayed. | Charts and Charting in Excel | |||
| Frogs in the pond - percentages not numbers | Charts and Charting in Excel | |||
| How do I change numbers and percentages in a formula?? | Excel Worksheet Functions | |||
| Change percentages to numbers | Excel Worksheet Functions | |||
| showing percentages in pie charts | Charts and Charting in Excel | |||
Linear Mode
