#### Muthukrishnan V

##### Board Regular

- Joined
- May 29, 2008

- Messages
- 149

- Office Version
- 365

- Platform
- Windows

If A1 is >10000 but <20000, then 3% of D1.

If A1 is >20000 but <30000, then 5% of D1

If A1 is >30000, then 6% D1.

For example:

if A1 is 17000 and D1 is 1000, then 3% of D1: Output is 30.

If A1 is 29000 and D1 is 1000, then 5% of D1: Output is 50.

If A1 is 35000 and D1 is 1000, then 6% of D1: Output is 60.

Request formula.