Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2007
    Location
    Big City
    Posts
    62

    Unanswered: Error in calculate the diff between 2 numbers

    Hello,
    Need help to calculate the difference between two numbers as a percentage.
    I have an excel file with data (Budget08 (by months), Actual07(by months))
    Here the Formula I have to calculate the difference as a percentage
    =IF(G2=0,"",IF(I2=0,1,((G2-I2)/I2)))
    And I have problems, because it show
    the incorrect numbers such as - 496.9%

    PLEASE HELP....
    THANK YOU


    This is an exanple:

    G I J
    -------------------------------------------
    JanBud08 JanAct07 Cng %
    -------------------------------------------
    7 $0 $8,117
    8 $0 $0
    9 $85,000 $14,240 496.9%
    10 $6,500 $5,792 12.2%
    11 $3,500 $0 100.0%

  2. #2
    Join Date
    Apr 2007
    Location
    Big City
    Posts
    62
    The Numbers are correct, checked it. Thank you.

Posting Permissions

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