"If, Then" Formulas for multiple cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!!!
 
What if A1 is blank or 0?

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

Biff
 
try:
=IF(ISNUMBER(A3),A3,IF(ISNUMBER(A2),A2,IF(ISNUMBER(A1),A1,A3)))
 
=INDEX(A1:A3,MAX((A1:A3<>0)*ROW(A1:A3)))

ctrl+shift+enter, not just enter
 
You must log in or register to reply here.

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

Similar Threads

Excel formula, sum the value cell and if empty cell left blank 0
multiple IF formulas 8
Help Creating Excel Formula 4
Error with sum formula in excel 2007 4
Creating a formula relating to several cells 2
excel formula 1
Formula/Sum Question 2
Help on IF formula 5

Back
Top