| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF statement maybe?
Here's my problem....I want to assign values to a formulas outcome to be ranked in ascending or descending values. For instance: Cell F4= 5000 Cell G4= F4/365 (formula outcome= 13.698) Cell F5= 20000 Cell G5= F5/365 (formula outcome= 54.795) Cell F6= 7000 Cell G6= F6/365 (formula outcome= 19.178) etc, etc, etc.... Is there a way I can program Excel to assign 1 to the cell F5 series, 2 to the cell F6 series, and 3 to the cell F4 series such that cells F11 through 13 would show 1, 3, and 2 based on the rankings of the G columns outcome? If that doesn't make sense let me know...thanks in advance for any help that can be provided. -- whodey ------------------------------------------------------------------------ whodey's Profile: http://www.excelforum.com/member.php...o&userid=29596 View this thread: http://www.excelforum.com/showthread...hreadid=492977 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF Statement problem | New Users to Excel | |||
| If statement | Excel Discussion (Misc queries) | |||
| Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions | |||
| IF Statement | New Users to Excel | |||
| Statement | Excel Worksheet Functions | |||
Threaded Mode
