Excel Programming Help...........

C

cy

I have written an excel spreadsheet. There are six columns which
signify the days of the week on one worksheet. I have an allotment to
use per week. Sometimes my weeks are made up of 6 days, sometimes 5
or 4 or 3 or 2 or 1. I have successfully written the program to
spread the allotment among the correct number of days. Sometimes the
day itself varies. Example, Sat, Mon, Tue or Sat, Tue, Wed, Thur, Fri
or Wed, Thur, Fri. I have included these calculations as well. And
the allotment is equally split among the days.


Now I wish to be able to assign variable percents to each day, so that
the days in my week will have percents that total up to 100%.

Here is some of what I have written so far, but I am unable to figure
where to start to have variable percents. Can anyone suggest where to
start?


=IF(SAT=1,(1/Days)*'Weekly Entries'!K48,0)

=IF(FRI=1,'Weekly Entries'!K48*(1/Days),IF(FRI=2,(1/Days)*'Weekly
Entries'!K48,IF(FRI=3,(1/Days)*'Weekly
Entries'!K48,IF(FRI=4,(1/Days)*'Weekly
Entries'!K48,IF(FRI=5,(1/Days)*'Weekly Entries'!K48,
IF(FRI=6,(1/Days)*'Weekly Entries'!K48,0))))))

As you may see, each day is equally weighted. I wish to have the
capability of spreading the percents as I wish.

Thanks,

Cy
 
Top