View Single Post
  #1   Report Post  
LE
 
Posts: n/a
Default IF A CELL HAS THE VALUE OF 0, I WANT IT TO GO CHECK THE NEXT ONE

I NEED A FORMULA OR FUNCTION THAT WILL CHECK CELL A1 IF IT HAS A ZERO OR A 1
OR ABOVE VALUE, IF IT HAS A ZERO VALUE IT MOVES ON TO CHECK CELL A2, IF IT
HAS A VALUE, IT DOESN'T GO ANY FURTHER AND DISPLAYS THAT VALUE?

I HOPE SOMEONE CAN HELP IAM STUMPED.

THANK YOU