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

.