division in design table

Discussion in 'SolidWorks' started by Guest, Jul 13, 2008.

  1. Guest

    Guest Guest

    How do I do division in a design table when I want more than just the
    integer returned. or do I just calculate that by hand and insert it into the
    table.

    Bob
     
    Guest, Jul 13, 2008
    #1
  2. You should be able to manipulate it just like any spreadsheet. Set your
    cell format to how many decimal places you want, put your formula in the
    cell, and it should work.

    Keep in mind that if you change a value that is driving another with your
    formula, that driven dim won't update until you open the DT, so make your
    changes in the DT.

    WT
     
    Wayne Tiffany, Jul 16, 2008
    #2
  3. Guest

    Guest Guest

    The qoutient command only returns the integer value of the division. I
    usually get around this if I am dividing by a fixed number I just divide by
    the reciprocal instead but in this case I need to calculate the reciprocal I
    would rather not do it by hand. If I have to do that it is easier to draw
    the sketches in AutoCAD and export them to SW.

    Bob
     
    Guest, Jul 16, 2008
    #3
  4. I'm not sure what we are missing about our discussion. In the cell that I
    want the number, I put in "=B3/2" of course without the quotes, and I get
    how ever many decimal places as I have set.

    WT
     
    Wayne Tiffany, Jul 16, 2008
    #4
  5. Guest

    Guest Guest

    All of the numbers to the right of the decimal point are always zero though.


    Bob
     
    Guest, Jul 17, 2008
    #5
  6. Now I'm really curious - can you send me an example?

    WT
     
    Wayne Tiffany, Jul 17, 2008
    #6
  7. Guest

    Guest Guest

    I found my problem = QUOTIENT(C3:3) returns 0, =PRODUCT(C3/3) works. Now I
    can make my gear design table.

    Bob
     
    Guest, Jul 17, 2008
    #7
  8. Why are you using QUOTIENT? As you have seen, it returns only an integer.
    Just try =C3/3

    WT
     
    Wayne Tiffany, Jul 17, 2008
    #8
Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.