I am trying to limit the results of a formula to a maximum value of 100. The basic formula looks like this:
=(F19*G21)+(G19*G22)+(H19*G23)+I19
If anyone can tell me what needs to be done to limit the result to a maximum of 100 that would be great!
=(F19*G21)+(G19*G22)+(H19*G23)+I19
If anyone can tell me what needs to be done to limit the result to a maximum of 100 that would be great!