Hi
Hoping someone can assist please. This query is actually for application in a SharePoint site, however I am using an Excel example to find out the solution so it can then be applied back into SharePoint.
I have four columns that calculate import duty on cigarettes and tobacco with the duty rate changing every 6 months. The columns are:
Column A: IMPORT DATE - in DD/MM/YYYY format
Column B: COMMODITY - input as either "CIGARETTES" or "TOBACCO"
Column C: QUANTITY
Column D: DUTY - calculated using =IF(B2="CIGARETTES",C2*1.1404,IF(B2="TOBACCO",C2*1629.14,0)) for Row 2
On 01/03/2023, the duty rates changed, so the duty calculation formula became =IF(B5="CIGARETTES",C5*1.6435,IF(B5="TOBACCO",C5*1663.36,0)) for Row 5
Is there a formula that before 01/03/2023, =IF(B2="CIGARETTES",C2*1.1404,IF(B2="TOBACCO",C2*1629.14,0)) is used and after/including 01/03/2023, =IF(B5="CIGARETTES",C5*1.6435,IF(B5="TOBACCO",C5*1663.36,0)) is used?
As mentioned, the duty rate changes every 6 months, so can the formula please include the ability to use a new IF condition to calculate the duty for dates after 01/09/2023?
Thanking you in advance.
Hoping someone can assist please. This query is actually for application in a SharePoint site, however I am using an Excel example to find out the solution so it can then be applied back into SharePoint.
I have four columns that calculate import duty on cigarettes and tobacco with the duty rate changing every 6 months. The columns are:
Column A: IMPORT DATE - in DD/MM/YYYY format
Column B: COMMODITY - input as either "CIGARETTES" or "TOBACCO"
Column C: QUANTITY
Column D: DUTY - calculated using =IF(B2="CIGARETTES",C2*1.1404,IF(B2="TOBACCO",C2*1629.14,0)) for Row 2
On 01/03/2023, the duty rates changed, so the duty calculation formula became =IF(B5="CIGARETTES",C5*1.6435,IF(B5="TOBACCO",C5*1663.36,0)) for Row 5
Is there a formula that before 01/03/2023, =IF(B2="CIGARETTES",C2*1.1404,IF(B2="TOBACCO",C2*1629.14,0)) is used and after/including 01/03/2023, =IF(B5="CIGARETTES",C5*1.6435,IF(B5="TOBACCO",C5*1663.36,0)) is used?
As mentioned, the duty rate changes every 6 months, so can the formula please include the ability to use a new IF condition to calculate the duty for dates after 01/09/2023?
Thanking you in advance.