| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
excel result return wrong calcuation result
The cell K2 = sum( I2*AS2)
in which I2= 20871 where the forumla here is I2=SUM(G2+H2) AS2 =0.077 - where the forumla here is =IF(ISERROR((AG2/(AG2+AJ2+AM2)*AD2)*A2*1.05/840/AF2), "",((AG2/(AG2+AJ2+AM2)*AD2)*A2*1.05/840/AF2)) 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 mY EMAIL: |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to Convert Figures into Text in Excel | Excel Worksheet Functions | |||
| Displays the number in text. (One thousand two hundred thirty four | Excel Worksheet Functions | |||
| Importing result from Access query to Excel but the result only c. | Excel Discussion (Misc queries) | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
| Excel - return a picture or range rows as the result of a formula | Excel Worksheet Functions | |||
Linear Mode
