| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
return wrong result of the cell
dear exceltips, The cell K2 = sum( I2*AS2) in which i2= 20871 AS2 =0.077. So, the correct result should be K2= 1607.067. Why it calculates to the cell of K2 result return now is 1598.588 - it is wrong answer. For details, pls see the wrapwrepusage.zip file It is a big different. Pls instruct ! thanks gary +-------------------------------------------------------------------+ |Filename: wrapwrepusage.zip | |Download: http://www.excelforum.com/attachment.php?postid=5186 | +-------------------------------------------------------------------+ -- garyww ------------------------------------------------------------------------ garyww's Profile: http://www.excelforum.com/member.php...o&userid=35818 View this thread: http://www.excelforum.com/showthread...hreadid=571251 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
return wrong result of the cell
If you look at AS2, the actual value of the cell is 0.07659375, but it is
formatted to appear as 0.077. Use the round function on the formula in AS2 =ROUND(IF(ISERROR((AG2/(AG2+AJ2+AM2)*AD2)*A2*1.05/840/AF2), "",((AG2/(AG2+AJ2+AM2)*AD2)*A2*1.05/840/AF2)),3) and things should work nicely. -- Hope this helps, MarkN "garyww" wrote: dear exceltips, The cell K2 = sum( I2*AS2) in which i2= 20871 AS2 =0.077. So, the correct result should be K2= 1607.067. Why it calculates to the cell of K2 result return now is 1598.588 - it is wrong answer. For details, pls see the wrapwrepusage.zip file It is a big different. Pls instruct ! thanks gary +-------------------------------------------------------------------+ |Filename: wrapwrepusage.zip | |Download: http://www.excelforum.com/attachment.php?postid=5186 | +-------------------------------------------------------------------+ -- garyww ------------------------------------------------------------------------ garyww's Profile: http://www.excelforum.com/member.php...o&userid=35818 View this thread: http://www.excelforum.com/showthread...hreadid=571251 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
| How to Convert Figures into Text in Excel | Excel Worksheet Functions | |||
| EXCEL:NUMBER TO GREEK WORDS | Excel Worksheet Functions | |||
| Syntax for inferred cell references | Excel Worksheet Functions | |||
| Conversion | Excel Worksheet Functions | |||
Hybrid Mode
