Simple field calculation

[stryder09]

I'm sure this is a very simple calculation but I need some help. I wish to add up the values in a field on a form. =[field1]+[field2]+[field3]+[field4]+[field5]. Easy enough but what I would like is that if the values of the 5 fields is greater than 20 for it to default to 20. Does anyone have any idea how I would write this equation?



Thanks for any help that I get.

Brad

[pbaldy]

One way would be an IIf():

=IIf(YourCalculation > 20, 20, YourCalculation)

[stryder09]

Worked perfectly thank you so much!

Brad

[pbaldy]

No problem Brad, and welcome to the site by the way!

[stryder09]

Thank you. Im fairly green so maybe posting alot! lol