ExcelBanter - IF THEN

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - IF THEN (https://www.excelbanter.com/excel-worksheet-functions/190518-if-then.html)

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

Teethless mama

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

Brad

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

All times are GMT +1. The time now is 02:35 AM.