Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
=IF((OR(B11="",B10="")),0,IF((B11<B10),((B11-B10)*24)+24,(B11-B10
This is from a time sheet download. I am trying to figure out how this
statement works. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
=IF((OR(B11="",B10="")),0,IF((B11<B10),((B11-B10)*24)+24,(B11-B10
If either B11 or B10 is blank, set the value of the cell to zero
Otherwise, if B11 is less than B10 set the value of the cell to ..... I could expand on this, but the formula was cut off in the subject line. -- Les Torchia-Wells "Dave" wrote: This is from a time sheet download. I am trying to figure out how this statement works. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
=IF((OR(B11="",B10="")),0,IF((B11<B10),((B11-B10)*24)+24,(B11-B10
Dave,
The formula you've put in the subject looks clipped so this may not be everything, but basically: If B11 Or B10 are empty the result is 0 and the rest of the formula is ignored. If B11 Or B10 contain any value at all then another condition is tested: If B11 < B10 then the result will be ((B11 - B10) * 24) + 24 If B11 B10 then the result will be B11 - B10 Hope that helps Best regards John "Dave" wrote in message ... This is from a time sheet download. I am trying to figure out how this statement works. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
=IF((OR(B11="",B10="")),0,IF((B11<B10),((B11-B10)*24)+24,(B11-B10
.....Sorry revise the second part to:
If 'both' B11 and B10 contain any value at all then another condition is tested: If B11 < B10 then the result will be ((B11 - B10) * 24) + 24 If B11 B10 then the result will be B11 - B10 .....must read the question:) "John" wrote in message ... Dave, The formula you've put in the subject looks clipped so this may not be everything, but basically: If B11 Or B10 are empty the result is 0 and the rest of the formula is ignored. If B11 Or B10 contain any value at all then another condition is tested: If B11 < B10 then the result will be ((B11 - B10) * 24) + 24 If B11 B10 then the result will be B11 - B10 Hope that helps Best regards John "Dave" wrote in message ... This is from a time sheet download. I am trying to figure out how this statement works. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
If changed array formula reduce ""\""\""\ - signs to #Missing, will it make ... | Excel Programming |