Return an amount with a criteria

[Marwan69]

Hello everyone and please pay a smile when you work this because it's a pain...

I have a table and I'd like to return an amount based on criteria. Let me explain below:
[TABLE="width: 417"]
<tbody>[TR]
[TD]Financial Figures (SR'000)[/TD]
[TD]Salama[/TD]
[TD]Yearly Change(%)[/TD]
[/TR]
[TR]
[TD]Cash & Cash Equivalents[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2013[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Insurance Operations(Takaful Operations)[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Cash on hand and at banks[/TD]
[TD]36,465[/TD]
[TD]-35.35%[/TD]
[/TR]
[TR]
[TD]Term deposits - (<= 3 mos)[/TD]
[TD]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Term deposits - (>3<12 mos)[/TD]
[TD]10,576[/TD]
[TD]190.65%[/TD]
[/TR]
[TR]
[TD]Shareholders' Operations[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Cash on hand and at banks[/TD]
[TD]33[/TD]
[TD]16639.39%[/TD]
[/TR]
[TR]
[TD]Term deposits - (<= 3 mos)[/TD]
[TD]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Term deposits - (>3<12 mos)[/TD]
[TD]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2014[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Insurance Operations(Takaful Operations)[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Cash on hand and at banks[/TD]
[TD]23,573[/TD]
[TD]-88.58%[/TD]
[/TR]
[TR]
[TD]Term deposits - (<= 3 mos)[/TD]
[TD]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Term deposits - (>3<12 mos)[/TD]
[TD]30,739[/TD]
[TD]-64.34%[/TD]
[/TR]
[TR]
[TD]Shareholders' Operations:[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Cash on hand and at banks[/TD]
[TD]5,524[/TD]
[TD]-99.86%[/TD]
[/TR]
[TR]
[TD]Term deposits - (<= 3 mos)[/TD]
[TD]0[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

I'd like the formula to return -35.35% under (Yearly change%) column but based on the following criteria:
I want the formula to read this criteriaInsurance Operations(Takaful Operations)) and this criteria: (Cash on hand and at banks) and therefore return to me the (Yearly change%). Hope is clear.

Why is that? Because I have two operations: (Insurance operations(Takaful Operations) and (Shareholders' Operations). I want first to return the yearly change% pertaining to insurance operations and then jump to shareholders' operations.

I wish this didn't cause pain to you guys!!!Many thanks,
Marwan

 

[Marwan69]

Many thanks RasGhul. It worked!

 

[RasGhul]

You're Welcome