"If, Then" Formulas for multiple cells
 

I am trying to compose a formula that will look at a series of cells. If the
first is blank (or zero), then it goes to the next. If the next is blank, it
goes to the third. So, if A3 has a value, use it, if not, go to A2. If A2
has a value and not A3, use it and if not, go to and use whatever is in cell
A1.

Someone please help. Thanks to all!!!

"If, Then" Formulas for multiple cells
 

What if A1 is blank or 0?

=IF(A3<0,A3,IF(A2<0,A2,IF(A1<0,A1,"")))

Biff

"readystate" wrote in message
...
I am trying to compose a formula that will look at a series of cells. If
the
first is blank (or zero), then it goes to the next. If the next is blank,
it
goes to the third. So, if A3 has a value, use it, if not, go to A2. If
A2
has a value and not A3, use it and if not, go to and use whatever is in
cell
A1.

Someone please help. Thanks to all!!!

"If, Then" Formulas for multiple cells
 

try:
=IF(ISNUMBER(A3),A3,IF(ISNUMBER(A2),A2,IF(ISNUMBER (A1),A1,A3)))

--
Regards,

Sebation.G
"readystate" ...
I am trying to compose a formula that will look at a series of cells. If
the
first is blank (or zero), then it goes to the next. If the next is blank,
it
goes to the third. So, if A3 has a value, use it, if not, go to A2. If
A2
has a value and not A3, use it and if not, go to and use whatever is in
cell
A1.

Someone please help. Thanks to all!!!

"If, Then" Formulas for multiple cells
 

=INDEX(A1:A3,MAX((A1:A3<0)*ROW(A1:A3)))

ctrl+shift+enter, not just enter


"readystate" wrote:

I am trying to compose a formula that will look at a series of cells. If the
first is blank (or zero), then it goes to the next. If the next is blank, it
goes to the third. So, if A3 has a value, use it, if not, go to A2. If A2
has a value and not A3, use it and if not, go to and use whatever is in cell
A1.

Someone please help. Thanks to all!!!