| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Percentile
I'm new to this so please be patient.
Trying to get a formula that will give me the following. Goal is 16, they reach 16 which = 100%. How do I generate a formula that would show that? -- Thank you very much. Tall Paul. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Percentile
Do you mean..
=H21/16% OR and format that to % =H21/16 If this post helps click Yes --------------- Jacob Skaria "TallPaul" wrote: I'm new to this so please be patient. Trying to get a formula that will give me the following. Goal is 16, they reach 16 which = 100%. How do I generate a formula that would show that? -- Thank you very much. Tall Paul. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Percentile
Hi,
With your mark (1 to 16) in a1 try this =(A1*6.25)/100 or to cap at 100% use this =MIN(1,(A1*6.25)/100) Both formatted as % Mike "TallPaul" wrote: I'm new to this so please be patient. Trying to get a formula that will give me the following. Goal is 16, they reach 16 which = 100%. How do I generate a formula that would show that? -- Thank you very much. Tall Paul. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Percentile | Excel Worksheet Functions | |||
| Percentile | Excel Worksheet Functions | |||
| to get its k-value from percentile and array | Excel Worksheet Functions | |||
| percentile | Excel Worksheet Functions | |||
| Percentile function | Excel Worksheet Functions | |||
Linear Mode
