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

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!

LE

Is this something like what you have in mind?

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

ExcelGirl


--
ExcelGirl
------------------------------------------------------------------------
ExcelGirl's Profile: http://www.excelforum.com/member.php...o&userid=25272
View this thread: http://www.excelforum.com/showthread...hreadid=387652