| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"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!!! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
"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!!! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
"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!!! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
"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!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combine logical formulas "if", "and", "or" | Excel Discussion (Misc queries) | |||
| Combining formulas, "and" & "or" to verify content of multiple cel | Excel Discussion (Misc queries) | |||
| "Control" plus "click" doesn't allow me to select multiple cells | New Users to Excel | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
| freeze window creates multiple "views" suffixed with ":n" | Excel Discussion (Misc queries) | |||
Linear Mode
