# Formula to give maximum 100% even when result of formula exceeds 100%

1. ## Formula to give maximum 100% even when result of formula exceeds 100%

I need help to understand how to enter a formula to give a maximum result of 100%

For example if sales target = 100,000 and sales achievement entered= 125'000 then I need the percent of sale achieved to show 100% not 125%

If the sale achieved entered= 75,000 then I need the same cell to show 75% achieved....

I'm sure their must be an easy way of doing this but I keep getting errors in the formula so any help would be appreciate.

2. ## Re: Formula to give maximum 100% even when result of formula exceeds 100%

hi AmirOmari, welcome to the forum. assuming sales target is in A1 & achievement in B1, try:
=MIN(B1/A1,1)

format to %

3. ## Re: Formula to give maximum 100% even when result of formula exceeds 100%

Thanks so much for the quick reply, it is perfect now I am able to continue preparing the report....

Best regards
Amir

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1