Recent content by SnapperHG1

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...

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...

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...

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...

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

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...

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...