Additional IF Function

  • Thread starter Thread starter Pran
  • Start date Start date
P

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
 
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!
 
=IF(S50="R",INDEX({"Sending";"in process";"Waiting fund";"On
paid";"paid"},IF(ISNUMBER(W50:Z50),COUNT(W50:Z50)+1)),IF
(S50="I","Irreclaimable",""))
 
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"
 
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.
 
Back
Top