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

[-= Luca =-]

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)

 

[Paul Lautman]

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)

I have done some playing with this workbook. For some reason (for which I
cannot find any setting), =TRUE in a cell on the sheet calc shows as 1
whilst =FALSE shows as a blank cell, whilst on calc2 they show as TRUE and
FALSE.

Of course since dati!C3 is not equal to "Tramoggia", the 4 on sheet calc is
incorect, but I cannot see what is doing this.

 

[G Lykos]

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 =-]

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]

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