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 killer23

  1. killer23

    Help with Index / Match / Nested If Statement

    Good to go - thanks skip - I'll give it a go.
  2. killer23

    Help with Index / Match / Nested If Statement

    Okay - almost there. The column counts are off in my "sample". LocID = Column 1 Primary Y/N = Column 8 Business Unit = Colum 2 Sorry about confusing things.
  3. killer23

    Help with Index / Match / Nested If Statement

    There is only one Y per LocID
  4. killer23

    Help with Index / Match / Nested If Statement

    Hi Skip - LocID Primary Y/N Business Unit ABC1 Y GOV ABC1 N USMC FOR6 Y USN FOR8 Y USAF FOR10 N USAF FOR10 Y USMC The data is sequencial by LocID - I need to match the LocID, then Y, and...
  5. killer23

    Help with Index / Match / Nested If Statement

    Hello All - The following formula works but it does not work perfectly: INDEX(GMSL!$W$2:$W$5000,MATCH(A4,IF(GMSL!$H$2:$H$5000="Y",GMSL!$A$2:$A$5000,"Blank"),0)) However, instead of returning "Blank" if the data row is null or not a match, it returns 0. Even if I remove "Blank" is still get...
  6. killer23

    Excel Nested If Displays Muliple "False" Conditions

    That did the trick - thanks Blue Dragon for the solution.
  7. killer23

    Excel Nested If Displays Muliple "False" Conditions

    The breakdown should be based on age then score; ie. if over 46 years then criteria one, if between 40 - 45 yrs then criteria two and so on.
  8. killer23

    Excel Nested If Displays Muliple "False" Conditions

    All - I am attmepting to sort out a nested formula that will display only one result - i.e. 1st, 2nd, 3rd, Fail. "D2" referes to age while "P2" refers to the raw score of my event. When I run the follwing formula I get something like "FalseFalseFalse1"; when I only want the "1" to be...
  9. killer23

    IIf - Two Questions - And I'm Stumped

    MajP - It all works now - I was being "thick". Thanks so much for your expert help - here's a star and a Commedation. Regards, S/F Killer23
  10. killer23

    IIf - Two Questions - And I'm Stumped

    Alright - finally getting somewhere here. Thanks to MajP I have the Body Fat working in a query. Now I am stuck when I try to get my query to work within a form - PFT_History. The idea is that a clerk will fill in the required "raw" data (i.e. # of pull-ups, crunches, etc ...) and the query...
  11. killer23

    IIf - Two Questions - And I'm Stumped

    I'm feeling very much like a "rock" here. Perhaps I'm missing something very basic. Do "Public Function" codes go into "Modules" or somewhere else to run. I've tried each sample offered and can create modules, place that module into the appropriate "Control Source" on my form and get - -...
  12. killer23

    IIf - Two Questions - And I'm Stumped

    I'm code agnostic - meaning, I don't know how to code - thus I've come here to ask the experts. I concur that code would seem to be much more efficient for both issues rather than a lookup. The extent of my coding knowledge if very (VERY) basic IIf statements. I will try the public log...
  13. killer23

    IIf - Two Questions - And I'm Stumped

    MajP - For body fat I would prefer to utilize the formula - it works perfectly in excel, but access seems to choke on Log10 functions; or, perhaps, it's my lack of skill within access is what's choking it. Still no luck with your last solution however. By chance have already created such a...
  14. killer23

    IIf - Two Questions - And I'm Stumped

    MajP What shows in the control source of my unbound text is: =PFTClass([<<intAge>>],[<<intScore>>]) Both Age and Score are formatted as general numbers. Score is a field bound as such - =(Run_Score]+(P/U Score]+[Crunch_Score]) - if that has any bearing in the issues at hand. S/F Killer23
  15. killer23

    IIf - Two Questions - And I'm Stumped

    MajP Reserve Side Phoenix - 6th Engineer Support - Bulk Fuel Co C - 1st Platoon Commander Civ Side State of Az - Tech Service / Web Manager S/F Killer23
See more

Part and Inventory Search

Back
Top