Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |