ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Enter data and display function result in same cell (https://www.excelbanter.com/excel-discussion-misc-queries/95066-enter-data-display-function-result-same-cell.html)

ChrisR

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

Nikki

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



All times are GMT +1. The time now is 02:36 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com