Hello there,
I am looking for a formula that will cap the amount in E5 to 50.000, if it comes to 100% of the value of A5. Currently it is c going up to 70,000.
Thank You,
Avixion
50000 Cap
-
- Administrator
- Posts: 78394
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
-
- StarLounger
- Posts: 85
- Joined: 15 Apr 2017, 17:59
Re: 50000 Cap
It works great!
Thank you Hans!
Regards,
Avixion
Thank you Hans!
Regards,
Avixion