divide a month's target into weeks
Hi Shazzer,
Here is a novel approach that may or may not be useful.
Using your example
A1: 25
A2: 4
B1: =A2-1&" x "&INT(A1/A2)
C1: =1&" x "&INT(A1/A2)+MOD(A1,A2)
It needs a bit of refining to be useful, but could be a good starting point.
HTH
Martin
"Shazzer" wrote in message
...
Is there a formula which will divide a number up into whole numbers. I.e.
if
I have to acheive 25 sales in a month, in a 4 week month, I want to divide
it
up into 4 whole numbers to see how many I need each week. So week 3 of
the
weeks should read 6 and 1 of the weeks should read 7.
|