1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Excel formula question

Discussion in 'Microsoft Office Specialist (MOS)' started by Pete01, Jun 5, 2006.

  1. Pete01

    Pete01 Kilobyte Poster

    492
    23
    42
    I have a spreadsheet and I'm trying to find out how to make a formula:

    I have 3 columns- A B and C

    The formula I am trying to work out is :

    (A divided by B) multiplied by 1000 - In column C

    Is this doable? I've searched around a lot and can't quite find a difinative answer.
     
    Certifications: MCP (NT4) CCNA
    WIP: 70-669, Learning MSI packaging
  2. AJ

    AJ Administrator Administrator

    6,771
    102
    221
    =(A1/B1)*1000

    Try that. Of course change the cell numbers to suite. The formula goes into the C cell.
     
    Certifications: MCSE, MCSA (messaging), ITIL Foundation v3
    WIP: Looking at doing ..................
  3. Mr.Cheeks

    Mr.Cheeks 1st ever Gold Member! Gold Member

    5,369
    85
    190
    [in column c] =A1/B1*1000 ?

    So
    A1 is 50
    B1 is 2

    50 divided by 2 = 25

    25 x 1000 = 25000
     
  4. Pete01

    Pete01 Kilobyte Poster

    492
    23
    42
    All sorted now- Thanks guys :D
     
    Certifications: MCP (NT4) CCNA
    WIP: 70-669, Learning MSI packaging

Share This Page

Loading...