View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
John[_88_] John[_88_] is offline
external usenet poster
 
Posts: 205
Default =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.