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