# IF Cell is Greater than Range Equal 1 or 0 HELP

1. ## IF Cell is Greater than Range Equal 1 or 0 HELP

Hello All,

I am trying to have a cell do the following logic.

IF cell(P25) is greater than cells Q25:Z25 then 1, if false = 0.

Where is what I have tried with no luck:

=IF(P25>(\$Q\$25,\$R\$25,\$S\$25,\$T\$25,\$U\$25,\$V\$25,\$W\$25,\$X\$25,\$Y\$25,\$Z\$25),1,0)

=IF(P25>(Q25:Z25),1,0)

I keep getting the #VALUE in the cell where I want the formula.

I don't think it can process the range of cells.

Ideas?  Register To Reply

2. ## Re: IF Cell is Greater than Range Equal 1 or 0 HELP

I was able to come up with this. Its very messy but it works! Any way I can trim it down?

=IF(P25>Q25,1,0)*(AND(IF(P25>R25,1,0)))*(AND(IF(P25>S25,1,0)))*(AND(IF(P25>T25,1,0)))*(AND(IF(P25>U25,1,0)))*(AND(IF(P25>V25,1,0)))*(AND(IF(P25>W25,1,0)))*(AND(IF(P25>X25,1,0)))*(AND(IF(P25>Y25,1,0)))*(AND(IF(P25>Z25,1,0)))  Register To Reply

3. ## Re: IF Cell is Greater than Range Equal 1 or 0 HELP

=IF(P25>max(Q25:Z25),1,0)  Register To Reply

4. ## Re: IF Cell is Greater than Range Equal 1 or 0 HELP

hmm or maybe even...
=--(P25>max(Q25:Z25))  Register To Reply

5. ## Re: IF Cell is Greater than Range Equal 1 or 0 HELP

The first one worked beautifully! I WAS playing with MAX as I do have it in another formula for Games Back, but I seemed to have had it in the incorrect spot. This is great! Thank you!  Register To Reply

6. ## Re: IF Cell is Greater than Range Equal 1 or 0 HELP

Happy to help   Register To Reply