Re: Incorrect calculation when using data from an already calculated cell

Tech-Archive recommends: Fix windows errors by optimizing your registry


Round where desired.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@xxxxxxxxxxxxx
<ArgarLargar@xxxxxxxxx> wrote in message news:1194372697.247780.92690@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I am trying to do a simple Pro Rata calculation. $185 is paid for a
year of service. The service is cancelled during the year and money
is owed back to the customer. I am getting an error on what should be
a simple calculation.

Cell A18 is Number with 2 decimals 185.00
Cell A22 is Date 6/7/2007 as the start of the year of service
Cell A23 is Date 6/7/2008 as the end of the year of service
Cell A24 is Date 9/17/2007 which is when the service was cancelled.

Cell A25 is Number with 0 decimals 366. This is cell A23 - A22 to
calculate the number of days in the year of service. 2008 is a leap
year so this is 366.

Cell A27 is Number with 0 decimals 102. This is cell A24 - A22 to
calculate the number of days the service was used (6/7/2007 to
9/17/2007).

Cell A28 is Number with 0 decimals 264. This is cell A23 - A24 to
calculate the number of days the service was not used (9/17/2007 to
6/7/2008).

Cell A30 is Number with 3 decimals 0.721. This is A28/A25 to
calculate the pro rata amount of the unused service.

Cell A36 is Number with 2 decimals 133.44. This is the incorrect
result of A30 * A18. The correct answer should be 133.39. I should
see 133.39 if my calculation is A30*A18 but I see 133.44 instead.

Any ideas?

Thanks in advance, Argar Largar


.

Relevant Pages

  • Re: How do Imake a formula to- (Part 2)
    ... Does each team or individual contribute a certain amount of money to ... They were determined from the current prize list. ... decimals values do not have an exact equivalent. ... do the same for the cell that contains the dollars, ...
    (microsoft.public.mac.office.excel)
  • Re: display first or second match instead of #REF in INDEX ROW for
    ... consider is that the formula is *already* fairly calculation intensive. ... My thought is to insert a row in the calendar sheet where I can ... If no match, then cell remains blank. ... Source worksheet has 2350 rows and 3 columns. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: MDX non-leaf level aggregation performance issues
    ... How come when I use NonEmptyCrossJoin in my write-enabled cube, ... If I update a cell and then issue ... You may want to carefully examine your calculation design to ensure the safe ... use of NonEmptyCrossjoin, or consider migrating to SQL AS 2005. ...
    (microsoft.public.sqlserver.olap)
  • Re: Slow sheet data entry?
    ... withstanding) does not stop Excel from performing a calculate with each cell ... When you mentioned setting the calculation state via the ... This experience also sheads some light on disabling the events, ... calculations as warranted by cell changes. ...
    (microsoft.public.excel.programming)
  • Re: Getting around Dependency Tree Performance Problems
    ... Dim lCount As Long ... The Excel Calculation Site ... time a VBA UDF is executed, unless the calculation is initated from VBA: ... cell range on my system from 65 seconds to 2 seconds. ...
    (microsoft.public.excel.programming)