I got it! Lost a few neurons, but hey I've lost more to the demon alcohol...
;)

=IF(AND(B48=$H$26,B48<=$I$26),C48*$J$26,IF(AND(B4 8=$H$27,B48<=$I$27),C48*$
J$27,IF(AND(B48=$H$28,B48<=$I$28),C48*$J$28,IF(AN D(B48=$H$29,B48<=$I$29),C
48*$J$29,""))))

Thanks for all those who helped :)

/viz


On 17/7/05 11:19 AM, in article
, "viz"
wrote:




On 17/7/05 4:23 AM, in article , "Biff"
wrote:

Hi!

Downloaded your sample file.

What am I missing here?

How does 11/30/2004 equate to the 2nd qtr?

30th November 2004 is in the second quarter of the financial year in
Australia - where I live :) Other countries have different financial/tax
years - and different date formats. Australia is dd/mm/yy


Is "PAYG" some type of accounting/financial calculation technique?

It is the tax system for self employed people (contractors like myself)
where tax is Pay As You Go - tax is paid quarterly on earnings. In the old
days, we had to pay provisional tax - tax paid in advance each quarter.

HTH

/viz


Biff

"Krishnakumar"
wrote in message
news:Krishnakumar.1s966a_1121501107.3099@excelforu m-nospam.com...

Hi,

See the attachment.

HTH


+-------------------------------------------------------------------+
|Filename: QtrlyTax.zip |
|Download: http://www.excelforum.com/attachment.php?postid=3607 |
+-------------------------------------------------------------------+

--
Krishnakumar


------------------------------------------------------------------------
Krishnakumar's Profile:
http://www.excelforum.com/member.php...o&userid=20138
View this thread: http://www.excelforum.com/showthread...hreadid=387715