IFs with multiples criteria

CassieL

Board Regular
Joined
Jun 14, 2016
Messages
83
Cost per month%AllocationStart MonthJanFebMarAprMayJunJulAugSepOctNovDec
100050%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
 

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).

CassieL

Board Regular
Joined
Jun 14, 2016
Messages
83
I hope that the equation can put in below Jan and the rest will generate from the equation
 

CassieL

Board Regular
Joined
Jun 14, 2016
Messages
83

ADVERTISEMENT

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
 

Forum statistics

Threads
1,136,324
Messages
5,675,096
Members
419,549
Latest member
EliteBeat

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top