Thread: more than 7 nested if (revised)
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Roger Govier Roger Govier is offline
external usenet poster
  
Posts: 2,886
Default more than 7 nested if (revised)
Hi

Could you not use
=H8+INDEX($O$21:$O40,INT((H8-$H$7)*24))

--
Regards

Roger Govier


"sharmashanu" wrote in message
ps.com...
can you tell me the format of that function
tx




Reply With QuoteReply With Quote