Complex IF(AND statement to manipulate weighted grades

macropod · #1 06-16-2016, 07:24 AM

Did you try the array formula I posted? You can add the D3 test if you wish:
=IF(D3="","",IF((SUM(IF(K3:AF3>=69.5,1,0))=COUNT(K 3:AF3))*AG3<69.5,"F",IF(AG3 <79.5,"C",IF(AG3<89.5,"B","A"))))
No AND tests are necessary -blanks in the K3:AF3 range will be ignored.

ddeaton · #2 06-16-2016, 07:35 AM

Quote:

Originally Posted by macropod

Did you try the array formula I posted? You can add the D3 test if you wish:
=IF(D3="","",IF((SUM(IF(K3:AF3>=69.5,1,0))=COUNT(K 3:AF3))*AG3<69.5,"F",IF(AG3 <79.5,"C",IF(AG3<89.5,"B","A"))))
No AND tests are necessary -blanks in the K3:AF3 range will be ignored.

I did try it, it returns ##### (VALUE) - Also, I am not sure if I am reading your suggestion correctly but I need to check each cell individually to be greater than 69.5, the "SUM" function is confusing me.

TIA

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Counting Grades on Excel Spreadsheet	Lear2016	Excel	1	01-04-2016 12:58 PM
How to manipulate the entire image?	markg2	Drawing and Graphics	4	04-17-2014 04:52 AM
Software to create weighted hierarchy chart?	RichardD	Office	1	02-10-2012 07:56 PM
help me to manipulate excel data	ibor	Excel	2	02-01-2011 03:14 AM
How to manipulate Hyperlinks	mecaton2	Word	0	10-04-2010 06:18 AM