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

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.