View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default IF and ISBLANK Functions

What was wrong with the answers you were given to your previous posts?

Regards,
Fred.

"Patrick Bailey" wrote in message
...
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?