Additional IF Function

[Pran]

Hi,

I have formula array as follow
=IF(S51="R";IF(ISNUMBER(W51);IF(ISNUMBER(X51);IF(ISNUMBER(Y51);IF(ISNUMBER(Z51);"Paid";"On Paid");"Waiting Fund");"in process");"sending");"Cashless")

I would like to add more, if S51="C", then result will be cashless,
How can i modify by inserting this one?

Appreciate,
Pran

 

[Jacob Skaria]

Hi Pran

Currently the formula returns Cashless for anything other than R

=IF(S51="R",IF(ISNUMBER(Z51),"Paid",IF(ISNUMBER(Y51),"On
Paid",IF(ISNUMBER(X51),"Waiting Fund",IF(ISNUMBER(W51),"in
process","sending")))),IF(S51="C","Cashless","S51 not C or R Change this text
suit"))


If this post helps click Yes

 

[Jacob Skaria]

with semicolon as separator.

=IF(S51="R";IF(ISNUMBER(Z51);"Paid";IF(ISNUMBER(Y51);"On
Paid";IF(ISNUMBER(X51);"Waiting Fund";IF(ISNUMBER(W51);"in
process";"sending"))));IF(S51="C";"Cashless";""))

If this post helps click Yes