Stop a calcuation once a max is reached

[tobysdhc]

Hello all,

I have a calcuation set as the following

Form # A1
2

Median Score B1=50 + ( # number of weeks B2=30 X Expected Weekly growth B3=1.6) = Goal B4=98 (B1 + (B2*B3))


Is there a way to limit the goal that is returend? For example, in the above sample, when using form #2, the goal should not exceed 80?

Thanks for your feedback

 

[West Man]

try =Max(80,your formula)