Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TugboatEng on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. BLONG37

    How to remove shadows from shaded views in Inventor 2014 drawings

    Ok, after trying sever options, I was able to create an appearance that does what I need. I am not sure what settings did what, but I got it on the first try. After that I was able to go in and change the color so that I have 3 different appearances to use in our IPN files. Kind Regards, Brian
  2. BLONG37

    How to remove shadows from shaded views in Inventor 2014 drawings

    The company that I work for designs outdoor equipment and we create the consumer assembly instruction steps as inventor drawings. When we create the .ipn for the component explosion, we change the colors of all the components. We use snow for all the parts not included in the step and use cadet...
  3. BLONG37

    if statement calculation base on a list of words

    Never mind, I figured it out with conditional formatting. Thanks all for looking.
  4. BLONG37

    if statement calculation base on a list of words

    Skip, The only issue I have with your solution, it removes the cell borders once the formula completes the calculation. Is there any way to stop that? I know that its easy enough to go in a put the borders back in, but when you are dealing with a BOM that has several hundred components, it would...
  5. BLONG37

    if statement calculation base on a list of words

    SkipVought, read my OP. I believe I stated my needs quite clearly. As for the pictures, the cell with the formula is selected so the formula shows in the formula bar. Just to appease the masses, I am attaching a mock BOM. In the future, I would be best, if the OP does not give you the...
  6. BLONG37

    if statement calculation base on a list of words

    I need a way for excel to pick the correct formula based on the first word in the description. Kind Regards, Brian
  7. BLONG37

    if statement calculation base on a list of words

    Here is the other formula. Kind Regards, Brianhttp://files.engineering.com/getfile.aspx?folder=2604d2db-fc0c-448a-8658-0ea9439e3e36&file=CURRENT_SET_UP_2.PNG
  8. BLONG37

    if statement calculation base on a list of words

    I don't think that is exactly what I am looking for. The attached is one of the formulas I am currently using. Kind Regards, Brianhttp://files.engineering.com/getfile.aspx?folder=46c8a25c-25f1-45db-aae3-39c01a59b2f9&file=CURRENT_SET_UP.PNG
  9. BLONG37

    if statement calculation base on a list of words

    Here is the extra qty table I have to use. Kind Regards, Brianhttp://files.engineering.com/getfile.aspx?folder=158cc1d2-788c-45a7-aa6d-5562da881d31&file=extra_qty.PNG
  10. BLONG37

    if statement calculation base on a list of words

    Hi all, I need some help. I am trying to automate a BOM creation task. We have three columns, extended qty, actual qty, and description. I also have a list of hardware that details how many extra get put in hardware bags based on a type. I would like to create a nested if statement that will add...

Part and Inventory Search

Back
Top