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