Hi there,

I have formula array as below :
=IF(S50="R";IF(ISNUMBER(W50);IF(ISNUMBER(X50);IF(I SNUMBER(Y50);IF(ISNUMBER(Z50);"Paid";"On Paid");"Waiting Fund");"in process");"sending");"Cashless")

Now, If I type "I" in S50, the result should be "Irreclaimable"
Kindly please help me to modify the formula,

THank you,
Pran

Try this€¦

=IF(S50="R","Waiting Fund",IF(S50="I","IRRECLAIMABLE",IF(ISNUMBER(W50), "In
Process",IF(ISNUMBER(X50),"Sending",IF(ISNUMBER(Y5 0),"Cashless",IF(ISNUMBER(Z50),"Paid","On Paid"))))))

If this post helps, Click Yes!

--------------------
(Ms-Exl-Learner)
--------------------



"Pran" wrote:

Hi there,

I have formula array as below :
=IF(S50="R";IF(ISNUMBER(W50);IF(ISNUMBER(X50);IF(I SNUMBER(Y50);IF(ISNUMBER(Z50);"Paid";"On Paid");"Waiting Fund");"in process");"sending");"Cashless")

Now, If I type "I" in S50, the result should be "Irreclaimable"
Kindly please help me to modify the formula,

THank you,
Pran

=IF(S50="R",INDEX({"Sending";"in process";"Waiting fund";"On
paid";"paid"},IF(ISNUMBER(W50:Z50),COUNT(W50:Z50)+ 1)),IF
(S50="I","Irreclaimable",""))


On Oct 22, 9:40*am, Pran wrote:
Hi there,

I have formula array as below :
=IF(S50="R";IF(ISNUMBER(W50);IF(ISNUMBER(X50);IF(I SNUMBER(Y50);IF(ISNUMBER(Z50);"Paid";"On Paid");"Waiting Fund");"in process");"sending");"Cashless")

Now, If *I type "I" in S50, the result should be "Irreclaimable"
Kindly please help me to modify the formula,

THank you,
Pran

It doesnt work,

no matter what I fill or not in cell between W till Z, result is "sending"
(with S50=R)
if S50=I, result is "blank"

"muddan madhu" wrote:

=IF(S50="R",INDEX({"Sending";"in process";"Waiting fund";"On
paid";"paid"},IF(ISNUMBER(W50:Z50),COUNT(W50:Z50)+ 1)),IF
(S50="I","Irreclaimable",""))


On Oct 22, 9:40 am, Pran wrote:
Hi there,

I have formula array as below :
=IF(S50="R";IF(ISNUMBER(W50);IF(ISNUMBER(X50);IF(I SNUMBER(Y50);IF(ISNUMBER(Z50);"Paid";"On Paid");"Waiting Fund");"in process");"sending");"Cashless")

Now, If I type "I" in S50, the result should be "Irreclaimable"
Kindly please help me to modify the formula,

THank you,
Pran

.

It doesnt work bro,

no matter what I fill or not in cell between W till Z, result is "waiting
fund"
(with S50=R)
if S50=I, result is "Irreclaimable" which i want to be.


"Ms-Exl-Learner" wrote:

Try this€¦

=IF(S50="R","Waiting Fund",IF(S50="I","IRRECLAIMABLE",IF(ISNUMBER(W50), "In
Process",IF(ISNUMBER(X50),"Sending",IF(ISNUMBER(Y5 0),"Cashless",IF(ISNUMBER(Z50),"Paid","On Paid"))))))

If this post helps, Click Yes!

--------------------
(Ms-Exl-Learner)
--------------------



"Pran" wrote:

Hi there,

I have formula array as below :
=IF(S50="R";IF(ISNUMBER(W50);IF(ISNUMBER(X50);IF(I SNUMBER(Y50);IF(ISNUMBER(Z50);"Paid";"On Paid");"Waiting Fund");"in process");"sending");"Cashless")

Now, If I type "I" in S50, the result should be "Irreclaimable"
Kindly please help me to modify the formula,

THank you,
Pran