| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF THEN
I'm trying to write an IF then to to test if a cell value is greater than
every value in another range of data (in a column). I tried =if(A1Range(A2:A30),1,0) and I also tried =if(A1A2:A30,1,0) for simple returns of 1 or 0. No luck. Does anyone have a suggestion? -- LB |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF THEN
=(A1MAX(A2:A30))+0
"LB" wrote: I'm trying to write an IF then to to test if a cell value is greater than every value in another range of data (in a column). I tried =if(A1Range(A2:A30),1,0) and I also tried =if(A1A2:A30,1,0) for simple returns of 1 or 0. No luck. Does anyone have a suggestion? -- LB |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF THEN
=--(a1max(a2:a30))
-- Wag more, bark less "LB" wrote: I'm trying to write an IF then to to test if a cell value is greater than every value in another range of data (in a column). I tried =if(A1Range(A2:A30),1,0) and I also tried =if(A1A2:A30,1,0) for simple returns of 1 or 0. No luck. Does anyone have a suggestion? -- LB |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
