I'm using Excel 2003, and having the following problem:
(though I may have put this in in the wrong question group; if so, I am sorry)

I'm trying to make a formula (or multiple ones, if necessary) that, by
plugging in two numbers (a total revenue value & the first day of the month),
it will create a set of percentages already assigned.

So far, I've got it set like this:
=IF(Sheet1!G6=1,SUM(Sheet1!D7*0.02),IF(Sheet1!G7=1 ,SUM(Sheet1!D7*0.044),IF(Sheet1!G8=1,SUM(Sheet1!D7 *0.054),IF(Sheet1!G9=1,SUM(Sheet1!D7*0.059),IF(She et1!G10=1,SUM(Sheet1!D7*0.049),IF(Sheet1!G11=1,SUM (Sheet1!D7*0.027),IF(Sheet1!G12=1,SUM(Sheet1!D7*0. 024))))))))

Where SHEET1!G6 = Sunday, G7 = Monday, G8 = Tuesday, G9 = Wednesday, G10 =
Thursday, G11 = Friday, G12 = Saturday, and D7 = revenue value.

However, whenever I plug in this into where I'd like the numbers to come
out, it puts the same value into every cell it's entered into.

What I'm hoping for is that if I plug in the revenue value into D7, and 1
into the Sunday value (G6) it will put the Sunday percentage (0.02) into the
1st, 8th, 15th, 22nd, and 29th day cells, the Monday percentage (0.044) into
the 2nd, 9th, 16th, 23rd, and 30th day cells, and so on with all seven days.
And if I put a 1 in the Monday value (G7), it will re-figure those
percentages so that the Monday percentage would fall on the 1st, 8th, 15th,
22nd, and 29th, etc.

Can someone please help me with this?