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

Search results for query: *

  1. jimnewguy

    Data Validation - Error Alert tab

    Thank you!
  2. jimnewguy

    Data Validation - Error Alert tab

    Is it possible to validate a formula and not a direct entry into a cell? Example: I want an error message to pop up if B5 = False cell (B5) =IF sum(B10:B13)>$100, True, False In this scenario if the formula shows up as False it does not have an error message pop up unless I directly click...
  3. jimnewguy

    Is it possible to have an "if statement" between 2 drop down lists?

    Is it possible to have an "if statement" between 2 drop down lists? Example: If cell A2 = YES Look at list B Else A2 = NO Look at list C
  4. jimnewguy

    Comparison Operators

    Thank you I have 600 different like combinations that need to go into it. Would this still be the best way to handle it?
  5. jimnewguy

    Comparison Operators

    Is it possible to do a select statement with a where clause that has a LIKE with multiple values. Example Select * from A where a.something LIKE ANY ('%ABC%','%BCD%')

Part and Inventory Search

Back
Top