• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Help with IF date is earlier than, IF later than....

D

dglazer

New Member
Hi: I am trying to do a spreadsheet for 2010 for a CRA audit for Canada, in which GST and HST were both used.


Basically, I am trying to figure out how to create a formula that

IF date is equal or less than 06/30/2010, then I will figure the tax at 5%, but later than 06/30/10 it will be 12%. I know I need an IF formula but cannot get it to work. Have been spending hours scouring message boards and help sites looking for a suggestion but no luck! Any help would be greatly appreciated!
 
Dglazer


Firstly, Welcome to the Chandoo.org Forums


Try: =Value*If( DateCell < Date(2010,06,30),5%,12%)
 
Thank you thank you thank you Hui. I would have never been able to figure that out myself. It works perfectly. Thanks again!
 
You must log in or register to reply here.
Back
Top