Notifications
Clear all
Topic starter
Pl.help me with this!
Posted : 03/03/2018 8:58 am
Hi Moiz
Welcome to the forum.
In cell C3 enter =IF(A3<DATE(2016,9,17),ROUND(B3*12.5%,0),ROUND(B3*13.5%,0))
or =ROUND(IF(A3<DATE(2016,9,17),12.5%,13.5%)*B3,0)
Copy down as many rows as needed.
Hope this helps.
Sunny
Posted : 03/03/2018 10:27 am
Topic starter
Thnx Sunny.It works!-moiz
Posted : 08/03/2018 9:52 am
Hi Moiz
Thanks for your feedback.
Happy to know it is working for you.
Cheers
Sunny
Posted : 08/03/2018 9:18 pm