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 cowski 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: *

  • Users: Box
  • Order by date
  1. Box

    Finding Fridays

    There is a way to determine the day of the week with formulas. Let's say A12 is the date. Then just do a "mod(a12,7)". This will return a value from 0 to 6. With 0 being Sunday, and 6 being Saturday. You could mod your current date. Then have a cell that subtracts that value...
  2. Box

    Nesting VLOOKUP and HLOOKUP (HOW TO DO IT???)

    I'll try it. I'll post the results. Thanks for the help
  3. Box

    Nesting VLOOKUP and HLOOKUP (HOW TO DO IT???)

    Thank you, Hadn't thought of that. I know it will work. But I'm still going to try to figure the syntax to get it all in one. It's one of those problems that I have to see solved. Being an engineer, I'm sure you understand. Thanks again, Gary
  4. Box

    Nesting VLOOKUP and HLOOKUP (HOW TO DO IT???)

    Back in the day, I used to be a Q-Pro wiz. I knew how to do it all. Then windows replaced dos, and Excel replaced Quattro Pro. Now I need to perform one of those old tricks, but I can't get the syntax just right, and maybe someone can help me. I want to nest an HLOOKUP inside a VLOOKUP. I...
  5. Box

    Round to ANY value equation,, ie..25-50-100-13 anything

    That is a great function. I never knew it existed. I've been using Excel for about 6 years, and never had any training. So when I couldn't find a function to do what I wanted, I had to make up my own. Thanks for pointing this out. But.... My equation could be used anywhere. Fortran...
  6. Box

    Round to ANY value equation,, ie..25-50-100-13 anything

    This may help someone. I recently developed a spreadsheet that calculated some pressure settings for a machine I was in charge of. The pressure gage read in 50 psi incriments, but my spreadsheet output was rounded to the nearest 1 psi. Excel will round to decimal places, not numbers...

Part and Inventory Search

Back
Top