Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |