| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What is this option for?
Hello again,
Based on a reading from previous question dtd. 28.4.07. "EXCEL IF FUNCTION" On an open workbook, I click ToolsOptionEDIT"fix decimals" [checked] e.g. 2 Cell A1 : 10209.00 Cell A2:10208.70 A3=IF(A1-A2=0.3,3,0) The expected result was not correct in due respect with the Option availed by my excel 2003. I wonder how will this option be indeed fairly adjust my needs with Formulas. Maybe a macro or something simple from our contributing members can help me with this.. Thanks for trying. -- regards, driller ***** birds of the same feather flock together.. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| preserve formatting option in pivot table option dialog box | Excel Discussion (Misc queries) | |||
| General option option not available | Excel Discussion (Misc queries) | |||
| keep source formatting is not an option in paste option button | Excel Discussion (Misc queries) | |||
| Reformat IF(ISERROR(....) : if 1st option returns empty, look at 2nd option. | Excel Worksheet Functions | |||
| Using VLOOKUP for one option, if this option is not valid than sec | Excel Discussion (Misc queries) | |||
Threaded Mode
