Return a value in a range of cells based on a previous formula

[gori1084]

Hi guys,

I got a question I can't seem to crack on my own.

I'm doing a financial model and I got one range of cells to populate (IF function) based on certain criteria. In a nutshell, things will populate in a cell if two conditions are met. Here is a sample: If A=X and B=Y, then populate the cell multiplying Z*V.

Now In the row below, I need to display a certain value in the cells based on a third condition.I do not know what cell I wanna populate so an IF function would be too long. I want to populate a cell based on:

If A=X and B=Y and the duration of the investment is say 8 quarters (or 2 years), populate the value Z*V in whatever cell meet the condition.

I'm attaching a sample sheet so that I hope someone could lend me a hand.

Thanks a lot in advance.

B