Hi: I have a complicated nested if formula that I need to design for an assignmentand I'm having some trouble:
Basically,
If cell 1 ="CASE" and cell 2 < 200 and cell 3 = "China" then shipping cost is $65
If cell 2 < 300 and cell 3 = "China" then shipping cost is $95
all others are...
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...