Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF and ISBLANK functions
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF and ISBLANK functions
Change the formula in C to
=ROUND(IF(ISBLANK(B32),0,B32-A32+1)/7,2) -- __________________________________ HTH Bob "Patrick Bailey" wrote in message ... 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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF and ISBLANK functions
col C formula should be
=ROUND(IF(ISBLANK(B32),0,B32-A32+1)/7,2) "Patrick Bailey" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF and ISBLANK functions | Excel Worksheet Functions | |||
isblank | Excel Discussion (Misc queries) | |||
isblank | Excel Worksheet Functions | |||
isBlank() | Excel Worksheet Functions | |||
Please make it easier to access the IS functions (e.g., isblank) . | Excel Worksheet Functions |