| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
If function with certain condition
I have 4 cells,
if 1st cell has number, then result is "A" if 1st & 2nd cell has number, then result is "B" if 1st,2nd & 3rd has number, then result is "C" if all cells has number, result is "D" How can i make this function? Regards, |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
If function with certain condition
What if 2nd & 3rd has number?
Stefi €˛Pran€¯ ezt Ć*rta: I have 4 cells, if 1st cell has number, then result is "A" if 1st & 2nd cell has number, then result is "B" if 1st,2nd & 3rd has number, then result is "C" if all cells has number, result is "D" How can i make this function? Regards, |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
If function with certain condition
besides those condition, value will be "in process"
"Stefi" wrote: What if 2nd & 3rd has number? Stefi €˛Pran€¯ ezt Ć*rta: I have 4 cells, if 1st cell has number, then result is "A" if 1st & 2nd cell has number, then result is "B" if 1st,2nd & 3rd has number, then result is "C" if all cells has number, result is "D" How can i make this function? Regards, |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
If function with certain condition
"Pran" wrote:
I have 4 cells, if 1st cell has number, then result is "A" if 1st & 2nd cell has number, then result is "B" if 1st,2nd & 3rd has number, then result is "C" if all cells has number, result is "D" How can i make this function? =IF(ISNUMBER(A1),IF(ISNUMBER(A2),IF(ISNUMBER(A3),I F(ISNUMBER(A4),"D","C"),"B"),"A"),"in process") |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
If function with certain condition
PS....
I wrote: =IF(ISNUMBER(A1),IF(ISNUMBER(A2),IF(ISNUMBER(A3),I F(ISNUMBER(A4),"D","C"),"B"),"A"), "in process") If you will ensure that A2 will not have a number unless A1 does, and A3 will not have a number unless A1 and A2 do, and A4 will not have a number unless A1, A2 and A3 do -- that is, A1:A4 are filled in in sequence, as dates of completion of sequential stages -- then: =CHOOSE(1+SUMPRODUCT(--ISNUMBER(A1:A4)), "in process", "A", "B", "C", "D") ----- original message ----- "JoeU2004" wrote in message ... "Pran" wrote: I have 4 cells, if 1st cell has number, then result is "A" if 1st & 2nd cell has number, then result is "B" if 1st,2nd & 3rd has number, then result is "C" if all cells has number, result is "D" How can i make this function? =IF(ISNUMBER(A1),IF(ISNUMBER(A2),IF(ISNUMBER(A3),I F(ISNUMBER(A4),"D","C"),"B"),"A"),"in process") |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
If function with certain condition
Both formula WORK,
Many thx bro, Pran, "JoeU2004" wrote: PS.... I wrote: =IF(ISNUMBER(A1),IF(ISNUMBER(A2),IF(ISNUMBER(A3),I F(ISNUMBER(A4),"D","C"),"B"),"A"), "in process") If you will ensure that A2 will not have a number unless A1 does, and A3 will not have a number unless A1 and A2 do, and A4 will not have a number unless A1, A2 and A3 do -- that is, A1:A4 are filled in in sequence, as dates of completion of sequential stages -- then: =CHOOSE(1+SUMPRODUCT(--ISNUMBER(A1:A4)), "in process", "A", "B", "C", "D") ----- original message ----- "JoeU2004" wrote in message ... "Pran" wrote: I have 4 cells, if 1st cell has number, then result is "A" if 1st & 2nd cell has number, then result is "B" if 1st,2nd & 3rd has number, then result is "C" if all cells has number, result is "D" How can i make this function? =IF(ISNUMBER(A1),IF(ISNUMBER(A2),IF(ISNUMBER(A3),I F(ISNUMBER(A4),"D","C"),"B"),"A"),"in process") |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional: stop function under certain condition | Excel Worksheet Functions | |||
| I am having trouble with the IF function and a compound condition | Excel Worksheet Functions | |||
| max function with condition | Excel Discussion (Misc queries) | |||
| adding part of a function on condition. | Excel Worksheet Functions | |||
| IF Function with formatting condition | Excel Worksheet Functions | |||
Hybrid Mode
