Enter data and display function result in same cell

G

Guest

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
 
G

Guest

if understand your questions:

highlight cells-- go to format-->selelct cell-->number-->percentage--ok

now when you type 20 you will get 20%
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how can we enter at the same time maintain a formula in a cell? 2
Negative percentage in data verification dropdown list? 2
If statement with multiple criteria and multiple results 3
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
Dont display anything above 100% 3
JUMP FROM "SEARCH" CELL TO RESULT WHEN PRESSING ENTER 1
Display result in same cell as formula 2
Enter value, convert, read result from same cell 1

Top