# IFs with multiples criteria

#### CassieL

##### Board Regular
 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

### 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).

#### Special-K99

##### Well-known Member
What's below Jan Feb Mar etc?

#### CassieL

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

#### Nishant94

##### Well-known Member
In D2 use:

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

#### CassieL

##### Board Regular

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

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

You're Welcome.

Replies
20
Views
132
Replies
2
Views
190
Replies
5
Views
108
Replies
11
Views
149
Replies
0
Views
121

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.

### Which adblocker are you using?

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

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