Announcement

Collapse
No announcement yet.

Multiplying in EXCEL

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Multiplying in EXCEL

    THis is what i got:

    60 75,000 = ###

    I am trying to multiply 75,000 and 60 but 60 needs to be a percentage = .6

    but still show 60. SO i need a formular thoat multiplies 75,000 and the percentage of 60. How would i do that
    2002 Mitsubishi Galant
    Progress: 90% [-▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓- ->

    Carputer Specs:
    Via M10K
    512mb Ram
    60GB HDD
    Souund Blaster Audigy2 NX
    OPUS ITX PC Case


  • #2
    did you try

    =70000*.6
    or
    =70000*,6 (depending on your locale settings)

    ### might also be that the column width isnt enough
    Roy

    2005 Range Rover 4.4
    Any ideas for putting a PC in this? :)

    Comment


    • #3
      format the cell for the way you want the number to read
      99.9% complete.

      http://www.cardomain.com/ride/212327

      Comment


      • #4
        =75,000*.6

        The ####'s usually mean you need to make the column wider to see the answer.
        Originally posted by ghettocruzer
        I was gung ho on building a PC [until] just recently. However, between my new phone having internet and GPS and all...and this kit...Im starting to have trouble justfiying it haha.
        Want to:
        -Find out about the new iBug iPad install?
        -Find out about carPC's in just 5 minutes? View the Car PC 101 video

        Comment


        • #5
          If you format the '% column' to be a % it should automatically calculate it as the .6

          As for the ###, like above, that ususally means your column needs to be widened. You need space for atleast 5 digits.

          Comment


          • #6
            put 60 in one cell (A1) and 75 000 in the second cell (B1). In the third cell write "=(A1/100)*B1" Simple. It will show 60 and you will multiply 75000 by .60
            Installed
            Asus A7N8X-VM - AMD Mobile Athlon 2400
            512 Ram - 60GB HD - Opus 150w
            Lilliput 7" - Rikaline 6010
            [00000000000001100010-] 98% Completed

            Check Out My Install!!!

            Comment


            • #7
              dude i was doing this for a lab yesterday. 75000*.6 than format the cell to show as a percentage. right click format cells
              i got dat ***** sittin on 22s! SUPERMAN EDITION!

              Comment


              • #8
                shhhhhhhhhhhh no use whoring in the ot!

                I answered and ur all just copying what I said
                Roy

                2005 Range Rover 4.4
                Any ideas for putting a PC in this? :)

                Comment


                • #9
                  no royn because he said he wants it to show as a percentage, so he has to format the cell to read out as percentage instead of general.
                  i got dat ***** sittin on 22s! SUPERMAN EDITION!

                  Comment


                  • #10
                    no, it wont be a percentage, only 60 is a percentage afair....
                    Roy

                    2005 Range Rover 4.4
                    Any ideas for putting a PC in this? :)

                    Comment


                    • #11
                      no, he wants the cell to show 60, but he wants to use .60 in the formula, so my suggestion is the correct one.
                      Installed
                      Asus A7N8X-VM - AMD Mobile Athlon 2400
                      512 Ram - 60GB HD - Opus 150w
                      Lilliput 7" - Rikaline 6010
                      [00000000000001100010-] 98% Completed

                      Check Out My Install!!!

                      Comment

                      Working...
                      X