Thread: Formula
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.newusers
ED
 
Posts: n/a
Default Formula

Thank you very much.

"RagDyeR" wrote:

Total hours in A20
Estimated hours in B20

=MIN(A20,B20)
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"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?