# Formula based on month for seasonal rates

#### spflueger

##### New Member
Using WinXP and Excel 2007 I need to setup a formula based on the date, (specifically the month) of the Monthly Report. If it is May through Sept. I need to use the Summer Rate from Summer Rate cell. If it is Oct through April then I must use the Winter rate cell in my calculation. I think this has to be an IF function but I don't know how to specify the month range to determine what rate cell to use to get the correct totals. I would really appreciate any help I could get

### Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

#### lenze

##### Legend
Hi and welcome to the board!!!
Maybe
Code:
``=IF(OR(MONTH(TODAY())={5,6,7,8,9,},"Summer Rate","Winter Rate")``
Substitute the rates in the formula.
lenze

#### spflueger

##### New Member
Lenze, I pasted the formula into the cell and added the rates but keep getting an error msg. The formula I pasted is:
=IF(OR(MONTH(TODAY())={5,6,7,8,9,},J26,I26)

I tried adding cell reference, but still get an error.
G15 --> Date which pulls from another worksheet (=PumpSum!B1) within the workbook which is formated mm/dd/yy. I need this to be a static date for the invoice. The error seems to be with the date.

Summer Rate --> J29
Winter Rate --> I29

Thank you so-o-o-o-o much for your help!
spflueger

#### barry houdini

##### MrExcel MVP
Try like this

=IF(OR(MONTH(G15)={5,6,7,8,9}),J26,I26)

#### lenze

##### Legend
Sorry, I missed a paren
Code:
``=IF(OR(MONTH(TODAY())={5,6,7,8,9,}),J26,I26)``
or Barry's fomula for a cell reference.

lenze

#### spflueger

##### New Member
That worked!!!! You're the greatest!

Replies
14
Views
422
Replies
5
Views
281
Replies
4
Views
199
Replies
6
Views
258
Replies
0
Views
233

1,190,613
Messages
5,981,939
Members
439,744
Latest member
Lazerbeakk

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