Formula designed to reimburse employees up to a certain amt?
 

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!

=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!