Set Formula On Right Hand Side Under Column?

I have created "front page" which allow user to enter their enquiry.

The formula will be as per below.

Issuing
World Bank -->if amount less then 500,000 = amount x 0.03125%; if amount from 500,000 - 2.5mil = amount x 0.015625%

Royal Bank -->amount x 0.0625% x no. of month (min charges 100)
Deutsche Bank -->0.025% per 3 months (min. S$50)

Stand By LC
World Bank -->0.02% per quarterly (3mths) - Amount X Rate X 1 (1 to 3mths) or X 2(4 to 6 mths) or X3 (7 to 9 mths) or X4 (10-12 mths)
Royal Bank -->0.25%p.a by day (Principal x Rate x Day divide by 360 day x 100)

Am I able to set a formula for example:-

1. When I click on Mode of payment - Issuing

2. On my right hand side under column "Bank Name" will list down all bank available

3. On my right hand side under column "Estimate cost" will auto calc the cost base on the bank's formula.