Additional IF Function
 

Hi,

I have formula array as follow :
=IF(S51="R";IF(ISNUMBER(W51);IF(ISNUMBER(X51);IF(I SNUMBER(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

Additional IF Function
 

Hi Pran

Currently the formula returns Cashless for anything other than R

=IF(S51="R",IF(ISNUMBER(Z51),"Paid",IF(ISNUMBER(Y5 1),"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


"Pran" wrote:

Hi,

I have formula array as follow :
=IF(S51="R";IF(ISNUMBER(W51);IF(ISNUMBER(X51);IF(I SNUMBER(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

Additional IF Function
 

with semicolon as separator.

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

If this post helps click Yes
---------------
Jacob Skaria


"Pran" wrote:

Hi,

I have formula array as follow :
=IF(S51="R";IF(ISNUMBER(W51);IF(ISNUMBER(X51);IF(I SNUMBER(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