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

G

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
 
E

Eric

LE said:
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!
 
E

ExcelGirl

LE

Is this something like what you have in mind?

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

ExcelGir
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top