IF and ISBLANK functions

P

Patrick Bailey

I have an excel worksheet that doesn't seem to be giving me the correct answer
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?
 
G

Gary Brown

The answer IS $5,120.98 UNLESS you change the formula in column C to be...
=round(IF(ISBLANK(B32),0,B32-A32+1)/7,2)

Hope this helps,
Gary Brown
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top