LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
divide by 0 error jmp JohnnyJomp New Users to Excel 2 February 29th 08 05:32 PM
Divide by zero error jimmy Excel Discussion (Misc queries) 1 June 13th 07 02:36 AM
Divide by zero error gregmosu Excel Discussion (Misc queries) 1 June 30th 06 05:00 PM
Sum and Divide Formula error JaB Excel Worksheet Functions 7 April 19th 06 07:47 PM
excel divide by zero error Titanium Excel Worksheet Functions 5 November 27th 05 12:15 AM


All times are GMT +1. The time now is 10:08 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"