Help me to solve this….

Originally Posted by nesh

Hey bro's…. How to solve this scenario's A1>1,A2=0 and A3>1 .So what I trying to do is, the zero on A2 must appear as alarm if A1,A3,>1 AND, IF A3,A4 and the following is =0, than is ="-" (if 0 value in between 2 to 3 column must appear as alarm) pls help me bro..

sorry
you need to explain it in a better way. it's difficult to understand what actually you want to get.

Apologies bro.. I'm pour in English, I edit back to make you more clear.

Originally Posted by nesh

Hey bro's…. help me on this... 1 From column A1 to A10 the value have to be 1, how to find out if there is any "0" in between A1 and A10. 2) If there is a "0" velue, how to formular that "0" to became "alarm".

if you want to change 0 to "alarm" then try this

select range A1:A10
press Ctrl+H
Find what: (enter here 0)
Replace withenter here "alarm") without quotes
and press Replace All tab.

OR

if you just want to see that which cell in range A1:A10 contains 0 then put in B1.

=IF(A1=0,"ALARM","Ok") and copy it down to B10

in column B it will show "ALARM" if there is 0 in left cell and "Ok" if there is not 0.

hope this would help you.

Regards.