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?

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?

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?

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?

That formula worked. Thank you. But now I have to complete this formula
only if a certain cell is filled out. How would I do that.

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

=IF(cell<"",formula,"")

--

Regards,

Peo Sjoblom

"ED" wrote in message
...
That formula worked. Thank you. But now I have to complete this formula
only if a certain cell is filled out. How would I do that.

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

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?

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?