Nested IF functions

L

Len

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Nest IF function 6
Insert Index into a Table 1
Improving Nested Formula Calculation Efficiency 2
Dealing with the error: unable to filter on excel hc home school 0
Cumulative formula for word table 0
Nested IF conditions 3
Nested If Function to be converted into a user-defined customfunction 1
Calculation of monthly payments per employee 0

Top