View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
driller driller is offline
external usenet poster
 
Posts: 740
Default 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..