If function with certain condition

[Pran]

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,

 

[Stefi]

What if 2nd & 3rd has number?
Stefi


„Pran†ezt írta:

 

[Pran]

besides those condition, value will be "in process"

 

[JoeU2004]

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),IF(ISNUMBER(A4),"D","C"),"B"),"A"),"in
process")

 

[JoeU2004]

PS....

=IF(ISNUMBER(A1),IF(ISNUMBER(A2),IF(ISNUMBER(A3),IF(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 -----

 

[Pran]

Both formula WORK,

Many thx bro,
Pran,

PS....


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 -----