IFs with multiples criteria

[CassieL]

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Cost per month[/TD]
[TD]%Allocation[/TD]
[TD]Start Month[/TD]
[TD]Jan[/TD]
[TD]Feb[/TD]
[TD]Mar[/TD]
[TD]Apr[/TD]
[TD]May[/TD]
[TD]Jun[/TD]
[TD]Jul[/TD]
[TD]Aug[/TD]
[TD]Sep[/TD]
[TD]Oct[/TD]
[TD]Nov[/TD]
[TD]Dec[/TD]
[/TR]
[TR]
[TD]1000[/TD]
[TD]50%[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Hi everyone,

I hope you can help me with the formula. My logic is if Start month = 1, then Jan - Dec = Cost per month* %Allocation

if start month = 2, Jan = 0, but Feb to Dec = cost per month * %Allocation
if start month = 3, Jan - Feb = 0, March to Dec = cost per month * % allocation

and so on to start month = 12.

How can I do that. I got confuse when I start writing my equation and I hope you can help me.

Thanks A LOT!

-CassieL

 

[Special-K99]

What's below Jan Feb Mar etc?

 

[CassieL]

I hope that the equation can put in below Jan and the rest will generate from the equation

 

[Nishant94]

In D2 use:

=IF(MONTH(1&D$1)>=$C2,$A2*$B2,0)

 

[CassieL]

Hi Nishant94, thanks for the code, however, when the start month = 4 (c2), G2 does not come out with number. In the following column, I should change =IF(MONTH2&E$1)>=$C2,$A2*$B2,0) right? I guess my question is what about E2 to O2. Thanks

 

[CassieL]

Hi Nishant94, I fugured it out! THANK YOU SO MUCH

 

[Nishant94]

You're Welcome.