Use MIN

=MIN(est,total)

will return total if less than estimate else est will be retruned

--

Regards,

Peo Sjoblom


"ED" wrote in message
...
I would like to display the total hours worked for the year but not more
than
the estimated hours. What kind of formula would I use?