Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2007
    Posts
    127

    Unanswered: Calculating Ratio

    I have two fields with data in it,

    for example -

    Field 1:
    2068
    4567
    5421
    5442
    2135

    Field 2:
    102
    212
    855
    218
    544

    What is the formula to work out a rato from the two fields?

    thanks in advance

  2. #2
    Join Date
    Dec 2004
    Posts
    37

    This may seem too simple, but

    are you after field 1 divided by field 2.

    then the answer is 1: the number calculated

    Hope this is the answer??

  3. #3
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    I think you're almost there, but I bet the OP doesn't want

    1:1.25

    Instead they want

    4:5

    (whole numbers only)

    Is this right matey?
    George
    Home | Blog

  4. #4
    Join Date
    Oct 2007
    Posts
    127
    both of you are really right,

    thanks

    how do i add the calculated cell into a Pivot Chart?

Posting Permissions

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