Neomatrix
New Member
- Joined
- Feb 3, 2021
- Messages
- 11
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
- Mobile
I have to cap/limit percentage value to show all percentages above 700% as +700%, and all higher then -700% as -700%. There should not be max or min then this range, final result is shown in I column. I have tried MIN formula, but it is great for positive, not for negative percentages.
Thank you so much
Thank you so much