Formula based on month for seasonal rates

spflueger

New Member
Joined
Mar 10, 2009
Messages
3
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 :confused:
 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).
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
 
Upvote 0
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
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,213,546
Messages
6,114,256
Members
448,557
Latest member
richa mishra

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
Back
Top