Additional IF Function

[Pran]

Hi there,

I have formula array as below
=IF(S50="R";IF(ISNUMBER(W50);IF(ISNUMBER(X50);IF(ISNUMBER(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

 

[Ms-Exl-Learner]

Try this…

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

If this post helps, Click Yes!

 

[muddan madhu]

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

 

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

 

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