Formula

[ED]

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

--

Regards,

Peo Sjoblom


"ED" <[email protected]> wrote in message
news:[email protected]...
> 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?

[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!
=====================================================

"ED" <[email protected]> wrote in message
news:[email protected]...
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?

[ED]

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" <[email protected]> wrote in message
> news:[email protected]...
> 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?
>
>
>

[ED]

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?

[Peo Sjoblom]

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

--

Regards,

Peo Sjoblom

"ED" <[email protected]> wrote in message
news:[email protected]...
> 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?

[ED]

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?

[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)




--

Regards,

Peo Sjoblom


"ED" <[email protected]> wrote in message
news:[email protected]...
> 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?