50000 Cap

avixion
StarLounger
Posts: 72
Joined: 15 Apr 2017, 17:59

50000 Cap

Post by avixion »

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
You do not have the required permissions to view the files attached to this post.

User avatar
HansV
Administrator
Posts: 71191
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: 50000 Cap

Post by HansV »

Use

=MIN(A5*E3-B5,50000)
Regards,
Hans

avixion
StarLounger
Posts: 72
Joined: 15 Apr 2017, 17:59

Re: 50000 Cap

Post by avixion »

It works great!

Thank you Hans!

Regards,
Avixion