Forum

Notifications
Clear all

Pl.help me with this!

4 Posts
2 Users
0 Reactions
60 Views
(@mz)
Posts: 2
New Member
Topic starter
 

Pl.help me with this!

 
Posted : 03/03/2018 8:58 am
(@sunnykow)
Posts: 1417
Noble Member
 

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
(@mz)
Posts: 2
New Member
Topic starter
 

Thnx Sunny.It works!-moiz

 
Posted : 08/03/2018 9:52 am
(@sunnykow)
Posts: 1417
Noble Member
 

Hi Moiz

Thanks for your feedback.

Happy to know it is working for you.

Cheers

Sunny

 
Posted : 08/03/2018 9:18 pm
Share: