IF and ISBLNAK functions
 

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?

IF and ISBLNAK functions
 

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" wrote:

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?

IF and ISBLNAK functions
 

Thank you all very much. My boss loves me now :)

"Sean Timmons" wrote:

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" wrote:

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?