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..
|