Complex IF(AND statement to manipulate weighted grades

		Microsoft Office Forums > Microsoft Excel > Excel
Complex IF(AND statement to manipulate weighted grades - better way?

FAQ

Thread Tools

Display Modes

06-16-2016, 07:24 AM

macropod

Windows 7 64bit Complex IF(AND statement to manipulate weighted grades - better way?

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,521

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.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 05:05 AM.