Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Thanks for the link. My original work around was to to use <.01 since these
are large dollars I'm working with, but the tip about using the Round function in the link works great. Thanks also to the other posters. RGS "T. Valko" wrote: See this: http://tinyurl.com/4jd3fa -- Biff Microsoft Excel MVP "rgs" wrote in message ... Is there a bug with logical functions and large numbers in Excel? =54574.47-52348.24=2226.23 returns true =4354574.47-4352348.24=2226.23 returns false the only difference in the above 2 lines is the extra 4300000 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Help with logical function | Excel Worksheet Functions | |||
Logical function | Excel Discussion (Misc queries) | |||
should it be if() or another logical function? | Excel Worksheet Functions | |||
logical function | Excel Worksheet Functions | |||
Logical Function | Excel Worksheet Functions |