| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help.. too difficult to put into words
I have a bunch of percentages that are on a 100% scale, but i need to create
a formula in excel that would scale it down to a 60% scale. for example i need create a function that would prevent 89.72% from exceeding 60%, i know the answer is 53.83%, but i don't know how to come up with to formula to calcualte that. im guessing i would use an IF THEN formula, =IF, but im not for sure. your help is appreciated. thanks!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can you display numbers as words in excel (eg. 10 as ten)? | Excel Discussion (Misc queries) | |||
| triadic combinations of words | Excel Worksheet Functions | |||
| Spell Checking - Special Words Not Picked Up by Excel | Excel Discussion (Misc queries) | |||
| how to change numbers into words, | Excel Discussion (Misc queries) | |||
| Creating a Microsoft Words document from an existing Excel spreads | New Users to Excel | |||
Threaded Mode
