Additional IF Function

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

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
 
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
 
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
 
Back
Top