Can You Help Fix Error

Hi There,

I am trying to write a formula that says that if logical 1 to 7 is all met then it returns an answer of M and if one entry is not true then equal blank.  See below for my formula attempt and the chart I have created.

IF(OR(AND(K13:K15=”NA”,K17:K19=”NA”,K8>=90,K9>=80,K10>=80,K11>=5)),”M”,””)

Basic Skills Determination
Accuplacer Score
Reading 90
Math 80
Sentences 80
Writing 5
ACT
English NA
Math NA
Composite Score   NA
SAT
Critical Reading   NA
Mathematics   NA
Combined Score   NA
TSI Requiarement Met   M

By: Jennifer Franklin

Leave a Reply

Your email address will not be published. Required fields are marked *