| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple functions, conditional functions | Excel Worksheet Functions | |||
| How to convert cell formula functions to code functions | Excel Discussion (Misc queries) | |||
| formula/functions for average and if functions | Excel Worksheet Functions | |||
| efficiency: database functions vs. math functions vs. array formula | Excel Discussion (Misc queries) | |||
| Looking for a site with functions that substitute the ATP functions | Excel Worksheet Functions | |||
Linear Mode
