Thread: help
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Greg Brow Greg Brow is offline
external usenet poster
 
Posts: 29
Default help


How can I make this work,

=IF(ISBLANK(F17),"",IF((G17-F17)*24<5,(G17-F17)*24,IF((G17-F17)*248,(G17-F17)*24-1,(G17-F17)*24-0.5)))

1st part works perfectly and the line below works aswell can someone please
tell me how to make the two into the same code please

=if(G18="Off line",7,"")

Thanks in Advance

Greg