View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Les Les is offline
external usenet poster
 
Posts: 240
Default =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.