Srikanth123
New Member
- Joined
- Nov 30, 2014
- Messages
- 1
Hi,
I need a formula to be developed for below parameters.
If cell value is <=5000 should show 25.
If cell value is >5000 <=10000 should show 50.
If Cell value is >=10001 <100000 should calculate 3/1000 on cell value with min-75 max-200.
If cell value is >=100001 should calculate 2/1000 on cell value with Max 300.
Anybody Pls help me on this. I appreciate your help..
I need a formula to be developed for below parameters.
If cell value is <=5000 should show 25.
If cell value is >5000 <=10000 should show 50.
If Cell value is >=10001 <100000 should calculate 3/1000 on cell value with min-75 max-200.
If cell value is >=100001 should calculate 2/1000 on cell value with Max 300.
Anybody Pls help me on this. I appreciate your help..