| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Additional IF Function | Excel Worksheet Functions | |||
| AVERAGESIFS Function - average cells that fall within a date rangeand meet additional criteria | Excel Worksheet Functions | |||
| Automatically Extend Formula in Count function with Additional Row | Excel Discussion (Misc queries) | |||
| Need additional help | Excel Worksheet Functions | |||
| cell ref in function formula change when inserting additional colu | Excel Worksheet Functions | |||
Hybrid Mode
