Forum

Notifications
Clear all

require a formula

2 Posts
2 Users
0 Reactions
52 Views
(@dharmendra-m-jasani)
Posts: 1
New Member
Topic starter
 

i have multi tax rates in column g like (12,5,18,28,5,12,18,28,28,5,12) and my tax summary part is below in invoice at b column. now i want a formula which fetched data from column g and appear result in column b in summary section with ascending order. but if any tax rate is not present in column g then result appear next rate.

i have attach my file here.

pls. help me in this topic

 
Posted : 03/07/2018 4:19 pm
(@sunnykow)
Posts: 1417
Noble Member
 

Please attach an Excel workbook with your sample data and the expected result.

 
Posted : 03/07/2018 7:17 pm
Share: