Limit results pf formula to <20

[idmherb]

I have a sheet that determines the span of start date to current date with the number of days. I need to allocate points for each entry. Each person's entry gets 1 point for every 3 months worked with a maximum of 20 points or five years. So far, I have been able to calculate the span of time into days, then divide the days by 30 to get the number of months, then divide the months by 4 to get the number of quarters (thus number of points), however the maximum point number is 20. How do I limit the results to end at 20?
Thanks for your help

 

[VoG]

Try

=MIN(20, your formula)

 

[Weaver]

=MIN(< your calculation here > , 20)

perhaps?

 

[Jonmo1]

Welcome to the board...

Use the MIN Function

=MIN(threshold, value)

So with a basic formula of say A1+B1
And you want a result no larger than 20

=MIN(20,A1+B1)


Hope that helps.

 

[Weaver]

Try

=MIN(20, your formula)

Nice edit....

 

[idmherb]

Thanks All ...worked like a charm!..... Well even better than the charm,...I tried that before I posted here