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]

Hi Luca,

Your right! It does drive you crazy. I can't find any reason for this to
happen.
When I recreated this situation in a new workbook they worked perfectly.
So that's all I can suggest just delete that workbook with it's strange
faults and start again.

HTH
Martin

PS If anyone is concerned about clicking on the download
link, I clicked on it when it was showing zero downloads,
played with the file for about half an hour and have
had no problems whatsoever.

Regards
Martin

Sorry i dont understand what wrong (cause i dont read English very well....)

^__^


"MartinW" ha scritto nel messaggio
...
PS If anyone is concerned about clicking on the download
link, I clicked on it when it was showing zero downloads,
played with the file for about half an hour and have
had no problems whatsoever.

Regards
Martin

Hi Martin, look what's Lykos tell to me....

----- Original Message -----
From: G Lykos
Newsgroups: microsoft.public.excel.programming
Sent: Friday, June 30, 2006 10:32 AM
Subject: The same IF (SE) formula give me two different number: why???


This has to do with working in Lotus 123 format. To resolve the apparent
issue with tab 'calc' - with that tab selected, go to Tools | Options |
Transition, and uncheck 'Transition formula evaluation'. The formulas will
then display the expected values.

Cheers!


"MartinW" ha scritto nel messaggio
...
Hi Luca,

Your right! It does drive you crazy. I can't find any reason for this to
happen.
When I recreated this situation in a new workbook they worked perfectly.
So that's all I can suggest just delete that workbook with it's strange
faults and start again.

HTH
Martin

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