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), Office 365' 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 01000001 01100100 01101101 01101001 01101110 Administrator

    6,855
    141
    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: Breathing in and out, but not out and in, that's just wrong
  3. Mr.Cheeks

    Mr.Cheeks 1st ever Gold Member! Gold Member

    5,371
    87
    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...