Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi there,
I have formula array as below : =IF(S50="R";IF(ISNUMBER(W50);IF(ISNUMBER(X50);IF(I SNUMBER(Y50);IF(ISNUMBER(Z50);"Paid";"On Paid");"Waiting Fund");"in process");"sending");"Cashless") Now, If I type "I" in S50, the result should be "Irreclaimable" Kindly please help me to modify the formula, THank you, Pran |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Need additional coding help | 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 |