Max Number

[odditie]

How can I set a cell to calculate a score (example G2/G32) and then also have it have a maximum value.

In otherwords, if G2/G32 is >2 it =2.

Thanks for any help!

Chris

[BenjieLop]

How can I set a cell to calculate a score (example G2/G32) and then also have it have a maximum value.

In otherwords, if G2/G32 is >2 it =2.

Thanks for any help!

Chris

=MIN(G2/G32,2)

[odditie]

Thanks a lot, if you don't mind, can you explain to me why that works?

[BenjieLop]

<< Thanks a lot,>>

You are welcome ... I am just glad that I can be of help.


<< if you don't mind, can you explain to me why that works? >>

The formula =MIN(G2/G32,2) basically means that it will return a value of whichever is LOWER between "G2/G32" and 2.

If (G2/G32) is lower than 2, then your value will always be what (G2/G32) is. However, if (G2/G32) is greater than 2, then the value that will be returned should only be 2 (since you imposed this limit).

I hope this explanation is clear enough and acceptable to you.

Regards.