Looking for some help after a lot of trial and failure...
I am trying to find a formula that will help me calculate the following:
if(and(M2>=39.4,J2="Female",K2=14),"Meets","Does Not Meet")
if(and(M2>=39.1,J2="Female",K2=15),"Meets","Does Not Meet")
if(and(M2>=38.9,J2="Female",K2=16),"Meets","Does Not Meet")
if(and(M2>=42.5,J2="Male",K2=14),"Meets","Does Not Meet")
if(AND(M2>=43.6,J2="Male",K2=15),"Meets","Does Not Meet")
if(and(M2>=44.1,J2="Male",K2=16),"Meets","Does Not Meet")
I would like to combine all of these into one formula in the same cell. This way I can apply it to my whole class:
1. 41.3 Female 14 Meets
2. 47.4 Male 15 Meets
3. 37.2 Female 14 Does Not Meet
4. 45.8 Male 16 Meets
Post a sample workbook so we don't have to make one up to test formulas:
(How to) Upload a Workbook directly to the Forum
(please do not post pictures or links to worksheets)
Click Advanced next to Quick Post button at the bottom right of the editor box.
Scroll down until you see "Manage Attachments",
Click the "Choose" button at the upper left (upload from your computer).
Select your file, click "open", click "upload"
Once the upload is completed the file name will appear below the input boxes in this window.
Close the Attachment Manager window.
Click "Submit Reply"
Note: Please do not attach password protected workbooks/worksheets
Ensure to disable any Workbook Open/Autorun macros before attaching!
What I would like to do in that highlighted cell is to have this formula, but it won't do it and I can't figure out how to make it work...
IF(and(M2>=39.4,J2="Female",K2=14),"Meets","Does Not Meet"),if(and(M2>=39.1,J2="Female",K2=15),"Meets","Does Not Meet"),if(and(M2>=38.9,J2="Female",K2=16),"Meets","Does Not Meet"),if(and(M2>=42.5,J2="Male",K2=14),"Meets","Does Not Meet"),if(AND(M2>=43.6,J2="Male",K2=15),"Meets","Does Not Meet"),if(and(M2>=44.1,J2="Male",K2=16),"Meets","Does Not Meet")
I just want to know which students in the ages of 14-16 meet and do not meet the standard. The issue is that each age and gender has a different standard (VO2Max). I am hoping for a way to compile the totals for meet and does not meet.
Thanks again.
MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
Posts
62,101
Re: Multiple if(and help
What's wrong with the solution you have been offered above? It seems to do what you have asked.
Ali Enthusiastic self-taught user of MS Excel who's always learning! Don't forget to say "thank you" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below theur user name on the left, if you wish.
Forum Rules (updated September 2018): please read them here.
How to use the Power Query code you've been given: help here. More about the Power suite here.
This is AWESOME! Huge help and gives me a blueprint for the rest of the spreadsheet. I may have to come back here in the ext few days, but you are awesome!
Thanks so much!
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
LinkBack URL
About LinkBacks
Register To Reply
Originally Posted by AliGW
Ben Van Johnson)
Bookmarks