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

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

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

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

--
^__^
o.g.a.v.o.s. [Onorevoli Grazie A Voi Ohhh Saggi]

2. ## Re: The same IF (SE) formula give me two different number: why???

-= Luca =- wrote:
> The same IF (SE) formula give me two different number: why???
>
> 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
>

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.

3. ## Re: 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!

"-= Luca =-" <news_group@tiscaRTI.it> wrote in message
news:1b4pg.21514\$zy5.440484@twister1.libero.it...
> The same IF (SE) formula give me two different number: why???
>
> 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
>
>
> --
> ^__^
> o.g.a.v.o.s. [Onorevoli Grazie A Voi Ohhh Saggi]
>
>

4. ## Re: The same IF (SE) formula give me two different number: why???

Hi Lykos,

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" <GLykos@CompuServe.com> ha scritto nel messaggio
news:%23rvQ3%23BnGHA.4604@TK2MSFTNGP02.phx.gbl...
> 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 =-" <news_group@tiscaRTI.it> wrote in message
> news:1b4pg.21514\$zy5.440484@twister1.libero.it...
> > The same IF (SE) formula give me two different number: why???
> >
> > 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]
> >
> >

>
>

5. ## Re: The same IF (SE) formula give me two different number: why???

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

Regards,
George

"-= Luca =-" <news_group@tiscaRTI.it> wrote in message
news:eZ7pg.21791\$zy5.445629@twister1.libero.it...
> Hi Lykos,
>
> 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" <GLykos@CompuServe.com> ha scritto nel messaggio
> news:%23rvQ3%23BnGHA.4604@TK2MSFTNGP02.phx.gbl...
> > 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 =-" <news_group@tiscaRTI.it> wrote in message
> > news:1b4pg.21514\$zy5.440484@twister1.libero.it...
> > > The same IF (SE) formula give me two different number: why???
> > >
> > > 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]
> > >
> > >

> >
> >

>
>

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1