View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson
 
Posts: n/a
Default The same IF (SE) formula give me two different number: why???

Tools|Options|transition Tab|Uncheck "transition formula evaluation"

Do it for all your sheets in the workbook.




-= Luca =- wrote:

The same IF (SE) formula give me two different number: why???

Hi, please help me to understund why this formula it wrong
download this (45kb)
Your download link: http://www.easy-sharing.com/538860/TN2.xls.html
look at calc/B3 and calc2/B3 you find the SAME formula with the SAME data
but the result it's different!!!!!!
Why? I come to be creazy

(sorry my bad English)

--
^__^
o.g.a.v.o.s. [Onorevoli Grazie A Voi Ohhh Saggi]


--

Dave Peterson