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

[LE]

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]

LE wrote:

> 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")))

ExcelGirl