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,

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,

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,

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

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

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