Thread: Divide by Zero Error
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
hkslater hkslater is offline
external usenet poster
  
Posts: 4
Default Divide by Zero Error
=ROUNDDOWN((VLOOKUP($D9,Period1,VLOOKUP(I$6,Column s,3,FALSE),FALSE)/VLOOKUP($D9,Period1,3,FALSE)*$E9)+(VLOOKUP($D9,Per iod2,VLOOKUP(I$6,Columns,3,FALSE),FALSE)/VLOOKUP($D9,Period2,3,FALSE)*$F9),0)
Reply With QuoteReply With Quote