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.


Basic Skills Determination
Accuplacer Score
Reading 90
Math 80
Sentences 80
Writing 5
English NA
Math NA
Composite Score   NA
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 *