Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if function
Not sure if this is the best way to go about this, but a scaled down
approach of what i'm trying to do is see if a value in one cell is greater than five other sells and display certain things based if that's true or false. Ultimately what i'm trying to do is rank the values in 6 cells and put in another cell their rank based on which cell has the higher number. This is the function i've been messing with: =IF(C3E3&C3G3&I3&K3&M3,1,2) Even if the function is false is always displays the true value of 1. Any advice, sites, or better ways to go about this will be appreciated. Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if function
Maybe,
=IF(C3MAX(E3,G3,I3,K3,M3),1,2) Mike "hal" wrote: Not sure if this is the best way to go about this, but a scaled down approach of what i'm trying to do is see if a value in one cell is greater than five other sells and display certain things based if that's true or false. Ultimately what i'm trying to do is rank the values in 6 cells and put in another cell their rank based on which cell has the higher number. This is the function i've been messing with: =IF(C3E3&C3G3&I3&K3&M3,1,2) Even if the function is false is always displays the true value of 1. Any advice, sites, or better ways to go about this will be appreciated. Thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if function
needed something like this:
=IF(AND(C3E3,C3G3,C3I3,C3K3,C3M3),1,2) |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if function
crap going about this all wrong. i would need too many nested If And
statements to have one cell check 5 other cells to see where it ranks in value. to many combinations. gonna have to repost the question. thanks for the response though. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ISBLANK function not working when cell is blank dut to function re | Excel Discussion (Misc queries) | |||
copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions |