Results 1 to 4 of 4

If formula from quattro pro to EXCEL

This is a discussion on If formula from quattro pro to EXCEL within the Excel Questions forums, part of the Question Forums category; Changed a formula from quatro pro to Excel. But formula did not convert. I would like a formula that will ...

  1. #1
    New Member
    Join Date
    May 2004
    Posts
    12

    Default If formula from quattro pro to EXCEL

    Changed a formula from quatro pro to Excel. But formula did not convert.
    I would like a formula that will read:

    If C10=0, or if D10=0, then =(C11-D11)/D11-1

    My problem is, when a Zero is in one of the columns, it gives me an error message.

    In quattro, the formula was :

    @IF(C10=0#OR#D10=,(C10-D10), (C10/D10)-1)

    Any help to have the same result in EXCEL? Thank you.

  2. #2
    MrExcel MVP fairwinds's Avatar
    Join Date
    May 2003
    Posts
    8,632

    Default Re: If formula from quattro pro to EXCEL

    Hi

    I would guess:

    =IF(C10*D10,C10/D10-1,C10-D10)
    "Fair Winds and Following Seas"

  3. #3
    MrExcel MVP Joe Was's Avatar
    Join Date
    Feb 2002
    Location
    Central Florida, USA
    Posts
    7,539

    Default Re: If formula from quattro pro to EXCEL

    Changed a formula from quatro pro to Excel. But formula did not convert.
    I would like a formula that will read:

    If C10=0, or if D10=0, then =(C11-D11)/D11-1


    =IF(OR(C10=0,D10=0),(C11-D11)/D11-1,"")
    JSW: Try and try again: "The way of the Coder!"

  4. #4
    Board Regular
    Join Date
    May 2003
    Location
    Katy, Texas
    Posts
    3,829

    Default Re: If formula from quattro pro to EXCEL

    Good answers, but... Shouldn't the possibility of D11-1 being 0 be considered? I would modify the above to consider this.

    For instance, I would modify Joe Was's formula to:
    =IF(D11-1=0,"",if(OR(C10=0,D10=0),(C11-D11)/D11-1,""))

    The first "" could be some warning message, instead.

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com