# Multiple if(and help

1. ## Multiple if(and help

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

Thanks for any help...

2. ## Re: Multiple if(and help

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
• 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).
• Once the upload is completed the file name will appear below the input boxes in this window.
• Close the Attachment Manager window.
Ensure to disable any Workbook Open/Autorun macros before attaching!

Here you go.
Thanks!

4. ## Re: Multiple if(and help

``Please Login or Register  to view this content.``
It chooses from two IF formulas based on male/female

5. ## Re: Multiple if(and help

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.

6. ## Re: Multiple if(and help

What's wrong with the solution you have been offered above? It seems to do what you have asked.

7. ## Re: Multiple if(and help

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!

8. ## Re: Multiple if(and help

Originally Posted by AliGW
What's wrong with the solution you have been offered above? It seems to do what you have asked.

9. ## Re: Multiple if(and help

(she is a he Ben Van Johnson)

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

## X vBulletin 4.1.8 Debug Information

• Page Generation 0.07012 seconds
• Memory Usage 9,132KB
• Queries Executed 16 (?)
Template Usage (36):
• (1)bbcode_code
• (1)bbcode_quote
• (1)footer
• (1)forumrules
• (1)gobutton
• (9)memberaction_dropdown
• (1)navbar
• (4)navbar_noticebit
• (6)option
• (2)postbit_attachment
• (9)postbit_legacy
• (9)postbit_onlinestatus
• (9)postbit_wrapper
• (1)spacer_close
• (1)spacer_open
• (1)tagbit_wrapper

Phrase Groups Available (6):
• global
• inlinemod
• postbit
• posting
• reputationlevel
Included Files (39):
• ./vbseo.php
• ./env.php
• ./vbseo/includes/functions_vbseo.php
• ./vbseo/includes/functions_vbseo_pre.php
• ./vbseo/includes/functions_vbseo_url.php
• ./vbseo/includes/functions_vbseo_createurl.php
• ./vbseo/includes/functions_vbseo_db.php
• ./vbseo/includes/functions_vbseo_vb.php
• ./vbseo/includes/functions_vbseo_seo.php
• ./vbseo/includes/functions_vbseo_misc.php
• ./vbseo/includes/functions_vbseo_crr.php
• ./vbseo/includes/functions_vbseo_cache.php
• ./vbseo/includes/functions_vbseo_hook.php
• ./vbseo/includes/functions_vbseo_startup.php
• ./includes/config.php
• ./global.php
• ./includes/class_bootstrap.php
• ./includes/init.php
• ./includes/class_core.php
• ./includes/functions.php
• ./includes/class_friendly_url.php
• ./includes/class_hook.php
• ./includes/functions_cforum.php
• ./includes/functions_bigthree.php
• ./includes/class_postbit.php
• ./includes/class_bbcode.php
• ./includes/functions_reputation.php
• ./includes/class_bootstrap_framework.php
• ./vb/vb.php
• ./vb/phrase.php
• ./packages/vbattach/attach.php
• ./vb/types.php
• ./vb/cache.php
• ./vb/cache/db.php
• ./vb/cache/observer/db.php
• ./vb/cache/observer.php
• ./includes/functions_notice.php

Hooks Called (50):
• init_startup
• friendlyurl_resolve_class
• database_pre_fetch_array
• database_post_fetch_array
• global_bootstrap_init_start
• global_bootstrap_init_complete
• cache_permissions
• fetch_foruminfo
• global_state_check
• global_bootstrap_complete
• global_start
• style_fetch
• global_setup_complete
• friendlyurl_redirect_canonical
• bbcode_fetch_tags
• bbcode_create
• postbit_factory
• postbit_display_start
• cache_templates
• template_register_var
• parse_templates
• notices_check_start
• notices_noticebit
• process_templates_complete
• reputation_image
• postbit_imicons
• bbcode_parse_start
• bbcode_parse_complete_precache
• bbcode_parse_complete
• postbit_display_complete
• memberaction_dropdown
• postbit_attachment
• tag_fetchbit
• tag_fetchbit_complete
• forumrules
• navbits
• navbits_complete