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