Pl.help me with this!|General Excel Questions & Answers|Excel Forum|My Online Training Hub

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

Hi Moiz

Thanks for your feedback.

Happy to know it is working for you.

Cheers

Sunny