| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I am getting a strange round off error in excel
when mixing data types: a real and a complex as in
=IMSUM(-G1/2,IMSQRT(H1)) if G1 and H1 are both exactly equal to 4, the answer whould be 0 see http://www.geocities.com/derekcowley/public/IMerror.xls and look at location I1 (highlighted). |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Round off values in Excel | Excel Discussion (Misc queries) | |||
| strange problem with links updates in excel | Excel Discussion (Misc queries) | |||
| strange problem: excel file does not open and background freezes i | Excel Discussion (Misc queries) | |||
| Why does a spreadsheet sent in Excel round numbers when mailed? | New Users to Excel | |||
| In Excel, how do you get it to not automatically round my dollars. | Excel Worksheet Functions | |||
Threaded Mode
