G
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?
the estimated hours. What kind of formula would I use?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
Peo Sjoblom
Use MIN
=MIN(est,total)
will return total if less than estimate else est will be retruned
=MIN(est,total)
will return total if less than estimate else est will be retruned
R
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?
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?
G
Guest
Thank you very much.
G
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.
only if a certain cell is filled out. How would I do that.
P
Peo Sjoblom
=IF(cell<>"",formula,"")
G
Guest
It didnt' work. What I entered is
=IF(X18<>"",MIN(S18,C18),"")
=IF(X18<>"",MIN(S18,C18),"")
P
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)
will return the MIN formula if blank it will return blank. What does X18
contain? Check with
=LEN(X18)