Luca, the results are consistent between the two tabs. You can experiment
further to satisfy yourself of that, and can read about Excel's Lotus
emulation if interested.

A general comment regarding the syntax in the formulas: the + following the
leading = is not necessary.

Regards,
George


"-= Luca =-" wrote in message
...
Hi Lykos,

thank's for your reply,
my files was born and developed with excel,
unchecking 'Transition formula evaluation' it seems that all it goes well
but are you sure that all the other excels formula dont change or come
crazy?

^__^
Luca


"G Lykos" ha scritto nel messaggio
...
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!


"-= Luca =-" wrote in message
...
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]