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!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
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...- killer23
- Thread
- Replies: 9
- Forum: Microsoft: Office
-
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...- killer23
- Thread
- Replies: 5
- Forum: Microsoft: Office
-
IIf - Two Questions - And I'm Stumped
I am creating a training database and am having a bit of trouble. Issue #1 - I have a series of fields in my form as follows: Age Gender Run_M Run_S Pull-ups Flex Crunches Score Class Each field calculates a score. The combined scores translate into a class (1st, 2nd, 3rd...- killer23
- Thread
- Replies: 28
- Forum: Microsoft: Access Forms
-
PFT Calculations
I am creating a database to track my Marines. Part of this tracking is calculating something called PFT scores (pysical fitness test). I have found code in java that will do the calculations for me, but I need the same functionality with in a Access DBase; the code is as follows - //...- killer23
- Thread
- Replies: 0
- Forum: Microsoft: Access Other topics
