Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Nested IF functions
Hi,
How to set a nested function within IF formula or macro like VB code to check column D for one or more specific texts ,if matches it returns the corresponding value from column J and go on the next row until it reaches the furnishing line for example, Column D Column J Column L 1) …travel… 200.00 IF(ISNUMBER(FIND("travel",$D1)),$J1,"") = 200.00 2) …air/fares 400.00 IF(ISNUMBER(FIND("travel",$D1)),$J1,"") = blank 3) …tolls… 50.00 IF(ISNUMBER(FIND("tolls",$D2)),$J2,"") = 50.00 4) …Btrips…travel… 124.00 Nested IF formula ??? = 124.00 5) …Btrips…travel… tolls.. 75.00 Nested IF formula ??? = 75.00 For item 4), Nested IF formula for one or more specific texts ( ie B'trip or travel ) For item 5), Nested IF formula for one or more specific texts ( ie B'trip or travel or tolls ) Is it possible to set the above function such as like or contain to check for one or more specific text from that row ? Please help, many thanks Regards Len |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Nested IF Functions | Excel Worksheet Functions | |||
Nested functions | Excel Discussion (Misc queries) | |||
Too many nested IF functions! | Excel Worksheet Functions | |||
NESTED IF FUNCTIONS | Excel Worksheet Functions | |||
Nested Functions with OR | Excel Worksheet Functions |