Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Enter data and display function result in same cell
I was wondering if it is possible to enter a value in a cell and return a
percentage from this value in the same cell. Example (using n=100) 20 (20.00%) 40 (40.00%) Here, 20 and 40 are entered values while the complimenting percentages are calculated and displayed in the same cell. The cells will need to display both the entered values and calculated percentages. Thanks in advance, Chris |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Enter data and display function result in same cell
if understand your questions:
highlight cells-- go to format--selelct cell--number--percentage--ok now when you type 20 you will get 20% "ChrisR" wrote: I was wondering if it is possible to enter a value in a cell and return a percentage from this value in the same cell. Example (using n=100) 20 (20.00%) 40 (40.00%) Here, 20 and 40 are entered values while the complimenting percentages are calculated and displayed in the same cell. The cells will need to display both the entered values and calculated percentages. Thanks in advance, Chris |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pivot table data display in cell | Excel Discussion (Misc queries) | |||
Function to not display until data entered | Excel Discussion (Misc queries) | |||
Excel control cell display of data with passwords | Excel Worksheet Functions | |||
How do I have a data table display cell names rather than values? | Excel Worksheet Functions | |||
Load active cell data via a function | Excel Worksheet Functions |