Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Nested If functions and Formulas
I am doing a time sheet and am having trouble doing IF functions and formulas
for cells. =SUM((B6-B5)*24,(B4-B3)*24) =IF(B7=0,"",SUM(B7-7.5)) What I'm trying to achieve is in B7 if B6=0, blank, if B6=7.5, blank, otherwise B7=B6-7.5 In B7 I want to show overtime or deduct time if less than 7.5 hrs How do I do this? Thanks -- Ginny |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Nested If functions and Formulas
Perhaps something like:
=IF(OR(B6=0,B6=7.5),0,B6-7.5) HTH Elkar "Ginny" wrote: I am doing a time sheet and am having trouble doing IF functions and formulas for cells. =SUM((B6-B5)*24,(B4-B3)*24) =IF(B7=0,"",SUM(B7-7.5)) What I'm trying to achieve is in B7 if B6=0, blank, if B6=7.5, blank, otherwise B7=B6-7.5 In B7 I want to show overtime or deduct time if less than 7.5 hrs How do I do this? Thanks -- Ginny |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Nested If functions and Formulas
That just gives me 0.00 in B7
-- Ginny "Elkar" wrote: Perhaps something like: =IF(OR(B6=0,B6=7.5),0,B6-7.5) HTH Elkar "Ginny" wrote: I am doing a time sheet and am having trouble doing IF functions and formulas for cells. =SUM((B6-B5)*24,(B4-B3)*24) =IF(B7=0,"",SUM(B7-7.5)) What I'm trying to achieve is in B7 if B6=0, blank, if B6=7.5, blank, otherwise B7=B6-7.5 In B7 I want to show overtime or deduct time if less than 7.5 hrs How do I do this? Thanks -- Ginny |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Nested If functions and Formulas
Sorry Elkar, it does work - thanks a bunch!!!
-- Ginny "Elkar" wrote: Perhaps something like: =IF(OR(B6=0,B6=7.5),0,B6-7.5) HTH Elkar "Ginny" wrote: I am doing a time sheet and am having trouble doing IF functions and formulas for cells. =SUM((B6-B5)*24,(B4-B3)*24) =IF(B7=0,"",SUM(B7-7.5)) What I'm trying to achieve is in B7 if B6=0, blank, if B6=7.5, blank, otherwise B7=B6-7.5 In B7 I want to show overtime or deduct time if less than 7.5 hrs How do I do this? Thanks -- Ginny |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Nested If functions and Formulas
Just me, but logically wouldn't you want B7 to be 0 for anything in B6 from zero to 7.5? Overtime doesn't kick in until after 7.5, right? =IF(B6<=7.5,0,B6-7.5) -- JBeaucaire ------------------------------------------------------------------------ JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=46792 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Nested If functions and Formulas
Not really because I also want it to show if you worked less than 7.5 how
much that would be - just don't want it to show anything if it's 0 or 7.5. Does this help? -- Ginny "JBeaucaire" wrote: Just me, but logically wouldn't you want B7 to be 0 for anything in B6 from zero to 7.5? Overtime doesn't kick in until after 7.5, right? =IF(B6<=7.5,0,B6-7.5) -- JBeaucaire ------------------------------------------------------------------------ JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=46792 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Nested If functions and Formulas
Could you please explain to us what you want SUM(B7-7.5) to give you that
B7-7.5 won't do? -- David Biddulph "Ginny" wrote in message ... I am doing a time sheet and am having trouble doing IF functions and formulas for cells. =SUM((B6-B5)*24,(B4-B3)*24) =IF(B7=0,"",SUM(B7-7.5)) What I'm trying to achieve is in B7 if B6=0, blank, if B6=7.5, blank, otherwise B7=B6-7.5 In B7 I want to show overtime or deduct time if less than 7.5 hrs How do I do this? Thanks -- Ginny |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Nested Functions | Excel Discussion (Misc queries) | |||
too many nested IF functions | Excel Worksheet Functions | |||
NESTED IF FUNCTIONS | Excel Worksheet Functions | |||
nested if functions? | Excel Discussion (Misc queries) | |||
Nested IF and MID functions | Excel Worksheet Functions |