+ Reply to Thread
Results 1 to 5 of 5

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

  1. #1
    -= Luca =-
    Guest

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

    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]



  2. #2
    Paul Lautman
    Guest

    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???
    >
    > 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.



  3. #3
    G Lykos
    Guest

    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 =-" <[email protected]> wrote in message
    news:[email protected]...
    > 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]
    >
    >




  4. #4
    -= Luca =-
    Guest

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

    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" <[email protected]> ha scritto nel messaggio
    news:%23rvQ3%[email protected]...
    > 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 =-" <[email protected]> wrote in message
    > news:[email protected]...
    > > 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]
    > >
    > >

    >
    >




  5. #5
    G Lykos
    Guest

    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
    leading = is not necessary.

    Regards,
    George


    "-= Luca =-" <[email protected]> wrote in message
    news:[email protected]...
    > 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" <[email protected]> ha scritto nel messaggio
    > news:%23rvQ3%[email protected]...
    > > 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 =-" <[email protected]> wrote in message
    > > news:[email protected]...
    > > > 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]
    > > >
    > > >

    > >
    > >

    >
    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

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