Beginner's question

[Vince56190]

Beginner's question, I would like the displayed value not to exceed a defined value ( 3543). is this the right formula: ((a*0.2766)-190),IF (a>3543,"3543,a)
Thx

[RobertZenz]

Using min would be easier:

min(3543, ((a*0.2766)-190))

min will select the smaller value, so either the result of the calculation, or 3543 if the result is larger.

[Vince56190]

Thanx n I will try that.