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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by SnapperHG1

  1. SnapperHG1

    Complex Table. Need specific value out for multiple spec

    Glenn, I think I understand. I'm going to print this off and have a go Tuesday am. It's now Friday pm and I've just spent the last three days doing nothing but Excel spreadsheets like this one and I'm going up the wall with them!! Many, many thanks. The more I read your explanation the more I...
  2. SnapperHG1

    Complex Table. Need specific value out for multiple spec

    xlbo, I have another sheet where I enter the criteria, such as Load Duration, member thickness, etc, and the result is the corresponding value in the table, i.e. A Long Term Load, in 47mm thick material, using an M12 bolt, with loading parrallel to grain would result in 2.04 in the table. (the...
  3. SnapperHG1

    Complex Table. Need specific value out for multiple spec

    Apologies. Good point! I need to select the apropriate figure from the body of the table dependant on whether the case is parallel to the grain, Long, Med or Short term, Member Thickness and Bolt dia. hence the complexity. I had considered If statements, but couldn't get my head around how I...
  4. SnapperHG1

    Complex Table. Need specific value out for multiple spec

    Hope that I'v not mislead too many people with the subject! I have relatively large table, 14 columns, and need figure from the body of the table based upon the Load Duration (Long Term, medium Term or Short and Very Short term), the member thickness and the bolt diameter. To further...
  5. SnapperHG1

    Only pass if two conditions met

    Thankyou so much! Had tried AND from another forum on Eng-Tips I think, but it had AND and If the other way around! 1st week in a new job, so double thanks
  6. SnapperHG1

    Office 2003 Small Business Licensing

    I understand that there is some way of contacting Microsoft and telling them that you have upgraded hardware, etc. As I understand it, and I'm prepared to be corrected if wrong, there are around three component changes allowed before MS think it's a new machine, and hence it won't install. I'm...
  7. SnapperHG1

    Only pass if two conditions met

    Hi folks, I've tried searching all the forums, etc based upon multiple If statements, and I'm damn sure this is a no brainer but I can't seem to crack it! If a value is less than span/360 *and* less than 12mm, pass. If not fail. I seem to be struggling with the AND part. Help would be...
See more

Part and Inventory Search

Back
Top