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

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?