Equation Problem

[Guest]

How can I write this equation to continue checking I56, I57,I58 and so on. Another words If I55> 0, B40, if not check I56>0 if not I57 ect. Can it go up 200 cells

=IF(I55>0,B40,""

Thanks for your help.

 

[Peo Sjoblom]

=IF(OR(I55>0,I56>0,I57>0,I58>0,and so on),40,0)

however you can use 30 arguments in an OR function. If the result should be
40 if any cell in let's say
I55:I255 is greater than zero you can use this

=IF(COUNTIF(I55:I255,">0"),40,0)

--

Regards,

Peo Sjoblom

How can I write this equation to continue checking I56, I57,I58 and so on.

Another words If I55> 0, B40, if not check I56>0 if not I57 ect. Can it go
up 200 cells?

 

[Kieran]

like
IF(MAX(I55:I255)>0,B40,"")
perhaps?