If you want the formula to be in Cell "c" then it can't also have the
default value unless it is hard coded into the formula:

=MIN(A1,11000)

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"Shelly" wrote in message
...
I can not find the correct formula for the following scenario:

Cell "a" has a number in it. I need cell "c" to show a set default number
if the number is column "a" is greater than the set number and for it to
show
the exact number is column "a" if the value is less than the set number.

IE: cell a = 5,868 cell c to show 5,868 since it is less than 11,000
--
Shelly