IFs with multiples criteria

[CassieL]

Cost per month

%Allocation

Start Month

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

1000

50%

1

<tbody>
</tbody>

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.