IF and ISBLNAK functions

[Patrick Bailey]

I have an excel worksheet that doesn't seem to be giving me the correct answer
I'm using Office 2003
The Row number is 32
Column A = 7/1/2008
Column B = 9/30/2008
Column C = 13.14
Column D = 4.5422
Column E = $110.00
Column F = $499.64
Column G = $389.64
Column H = $5,120.98

7/1/2008 9/30/2008 13.14 4.5422 $110.00 $499.64 $389.64 $5,120.98

The formula in column C is: =IF(ISBLANK(B32),0,B32-A32+1)/7
Columns D and E; 4.5422 and $110.00 are fixed numbers.
The formula in Column F is: =ROUND(D32*E32,2)
The formula in Column G is: =ROUND(F32-E32,2)
The formula in Column H is: =ROUND(G32*C32,2)
Column H returns $5,120.98 but the correct answer is $5,119.87
Can anyone help me with this?

 

[Sean Timmons]

C32 is 13.1429, not 13.14. Maybe you want to round that number as well, since
that's where your discrepancy is.

 

[Patrick Bailey]

Thank you all very much. My boss loves me now