Muthukrishnan V
Active Member
- Joined
- May 29, 2008
- Messages
- 272
- Office Version
- 365
- Platform
- Windows
Excel 2007.
Columns A1 and B1 contain numbers.
I want a formula to calculate:
If A1 <=500000 Output 0.
If A1 >500000 but <=1000000 output B1*10%
If A1 >1000000 output B1*15%
Columns A1 and B1 contain numbers.
I want a formula to calculate:
If A1 <=500000 Output 0.
If A1 >500000 but <=1000000 output B1*10%
If A1 >1000000 output B1*15%