The formula I posted checks if the cell (X18) is not blank, if not blank it
will return the MIN formula if blank it will return blank. What does X18
contain? Check with

=LEN(X18)




--

Regards,

Peo Sjoblom


"ED" wrote in message
...
It didnt' work. What I entered is
=IF(X18<"",MIN(S18,C18),"")

"ED" wrote:

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?