View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
Rick Rothstein \(MVP - VB\)[_2420_] Rick Rothstein \(MVP - VB\)[_2420_] is offline
external usenet poster
 
Posts: 1
Default Avoiding nested if statements?

Rick's solution didn't work, but again, I think it was because the
help I tried to give with the columns and rows wasn't clear.


Alright, assuming I got the column wrong (I still think the formula is
basically correct), put the following formula in D6 and copy it down (you
can copy it past your existing data if you want)...

=IF(C6="","",IF(C6<=B$1,D5-$H$4,INDEX(B$10:B$1000,1+DATEDIF(B$1,C6,"m"))))

Rick