Formula based on month for seasonal rates

[spflueger]

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

 

[VoG]

Hello and welcome to MrExcel.

Does this similar thread help? http://www.mrexcel.com/forum/showthread.php?t=378397

 

[lenze]

Hi and welcome to the board!!!
Maybe

=IF(OR(MONTH(TODAY())={5,6,7,8,9,},"Summer Rate","Winter Rate")

Substitute the rates in the formula.
lenze

 

[spflueger]

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]

Try like this

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

 

[lenze]

Sorry, I missed a paren

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

or Barry's fomula for a cell reference.

lenze

 

[spflueger]

That worked!!!! You're the greatest!