Formula

[Guest]

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?

 

[Peo Sjoblom]

Use MIN

=MIN(est,total)

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

 

[RagDyeR]

Total hours in A20
Estimated hours in B20

=MIN(A20,B20)
--

HTH,

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

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?

 

[Guest]

Thank you very much.

 

[Guest]

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.

 

[Peo Sjoblom]

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

 

[Guest]

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

 

[Peo Sjoblom]

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)