IF and ISBLANK 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 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? |
All times are GMT +1. The time now is 12:10 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com