Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

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

Recent content by 50gumbys

  1. 50gumbys

    Can I use 'Countif' to calculate results of IF statements??

    I have a number of cells that I've used an IF statement on to determine a certain result. I've simply used IF text entries in a range of cells to determine if values are - "low", "medium", "high". What I'd like to do is count the number of times any of these labels...
  2. 50gumbys

    "IF" STATEMENTS ?????

    I haven't read through all the posts here, but I did notice one comment that there is a limitation of seven levels of an IF statement. This is certainly true if you nest IF's one amongst the other. However, if you concatentate IF's together, there is no limit. eg...
  3. 50gumbys

    Combine 'conditional formatting' and 'TODAY()' function

    I'm sorry I haven't been back here - but I wanted to thank you so much for your solution to my problem!!! I appreciate that so much! You guys are great !!
  4. 50gumbys

    Combine 'conditional formatting' and 'TODAY()' function

    I want to use the 'Conditional Format' feature with the TODAY() function in order to check cells for dates that fall within 10 days of today's date. EG: Today's date: Nov 26 2003 cell dates: Nov 29 2003 (want the special format here) Dec 30 2003 (no special format) Would...
  5. 50gumbys

    Delay tasks by 2 hours?

    I use Project 98 and wondered if there is there a quick and easy way to delay certain tasks by 2 hours (eg - instead of starting at 6am, start at 8am). I know I can use the 'Levelling Delay' - but wondered is there anything else, something quick? Many thanks to all of you - really appreciate...
  6. 50gumbys

    Data Validation Lists

    Sorry about the delay - I was out of town and swamped by crocodiles! Please email me at lch1950@icqmail.com Many, many thanks!!!!
  7. 50gumbys

    Data Validation Lists

    Hi! I'm new here; but I just read this thread and I too, would very much like to know how to add a new item to a list. I'd appreciate getting a copy too. Many thanks! Lori

Part and Inventory Search