=min(a1,400)
where A1 is the cell that holds the claim value

"ddhawks" wrote in message
...
I am working on a reimbursement spreadsheet for our company's dental plan.
I
need to find out how to set it up to pay up to a certain amount. For
example, if somene turns in a claim for $550, and we only pay $400, how do
I
set up that formula?
Thanks!