IF A CELL HAS THE VALUE OF 0, I WANT IT TO GO CHECK THE NEXT ONE

[Guest]

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

 

[Eric]

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

STOP SHOUTING!

 

[ExcelGirl]

LE

Is this something like what you have in mind?

=IF(A20>0, A20, (IF(A20=0,A21,"A20 may negative")))

ExcelGir