|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
December 9th, 2005, 04:01 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
Formula
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? 
|
|
#2
December 9th, 2005, 04:03 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Formula
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?
|
|
#3
December 9th, 2005, 04:07 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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?
|
|
#4
December 9th, 2005, 04:20 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Formula
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?
|
|
#5
December 9th, 2005, 04:49 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Formula
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?
|
|
#6
December 9th, 2005, 04:56 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Formula
=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?
|
|
#7
December 9th, 2005, 05:32 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Formula
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?
|
|
#8
December 9th, 2005, 05:39 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Formula
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?
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Hide formula | skateblade | Worksheet Functions | 10 | October 15th, 2005 08:36 PM |
| adding row to forumla | carrera | General Discussion | 9 | August 23rd, 2005 10:24 PM |
| Formula checking multiple worksheets | sonic-the-mouse | Worksheet Functions | 11 | June 6th, 2005 06:37 PM |
| Formula to Count and Return Most common Value in a Dynamic Named Range | Tinä | General Discussion | 1 | October 23rd, 2004 11:26 PM |
| Formula to Count and Return Most common Value in a Dynamic Named Range | Tinä | General Discussion | 1 | October 23rd, 2004 08:51 PM |
Linear Mode
