As far as I can see, it will still need to be first calcluated month by
month, for the spreadsheet to be able to determine which quarter has
which months within it. Then the commission can be worked out
correctly.

Give me the weekend. and I will post you a reply that will work. got to
fit it around other projects i'm involved with.

But it should not be a problem.

I could also then just send you an attachment (Virus Free I promise)
with the example spreadsheet!

I will reply soon!

Take Care For Now!

Celtic_Avenger.

PS. Where are you from? Country wise?


--
Celtic_Avenger
------------------------------------------------------------------------
Celtic_Avenger's Profile: http://www.excelforum.com/member.php...o&userid=14101
View this thread: http://www.excelforum.com/showthread...hreadid=273006