Length limitation of cell formulas
 

Hi,

Thanks for your answer, let me make myself a bit clearer, let me attempt to
paste just what i wanted to do,

IF((IF(G9="",,IF(OR(G9<40,G9="ABS"),G$7,""))&"
"&IF(I9="",,IF(OR(I9<40,I9="ABS"),I$7,""))&"
"&IF(K9="",,IF(OR(K9<40,K9="ABS"),K$7,""))&" "&IF(M9="",,IF(OR(M9<40,
M9="ABS"),M$7,"")))="
",IF(R9<=0.99,"RPT",IF(R9<=1.49,"PASS",IF(R9<=2.39 ,"THIRD CLASS
HONOURS",IF(R9<=3.49,"SECOND CLASS HONOURS LOWER
DIVISION",IF(R9<=4.59,"SECOND CLASS HONOURS UPPER DIVISION",IF(R9<=5,"FIRST
CLASS HONOURS","")))))), "RPT" & " - " &
(IF(G9="",,IF(OR(G9<40,G9="ABS"),G$7,""))&"
"&IF(I9="",,IF(OR(I9<40,I9="ABS"),I$7,""))&"
"&IF(K9="",,IF(OR(K9<40,K9="ABS"),K$7,""))&" "&IF(M9="",,IF(OR(M9<40,
M9="ABS"),M$7,""))))

rjamison, i want either to compress this formula or any suggestion as to how
i can get to accomodate about 60 columns and return either of the conditions
within the formula.

A typical result template looks like this, NOTE this is a hugely shortened
version,

DEPARTMENT OF WAR & MONEY MANAGEMENT
FACULTY OF TERRORISM
UNIVERSITY OF THE WORLD, WORLD
400 LEVEL PRESIDENTIAL MANAGEMENT FINAL RESULTS
SESSION RESULT 2003/2004 FINAL YEARS
FIRST YEAR
SNO. MAT.NO. COURSES MODE MNSA NSS BUS 111 GP BUS 222 GP BUS 333 GP ACC
111 GP TCR TCE TGP GPA REMARKS
4 2 3 3
1 UJ/SS/100 GEORGE SOROS DE 12 8 32 0 75 5 ABS 0 80 5 12 5 25 2.08 RPT - BUS
111 BUS 333
2 UJ/SS/101 JAMES BROWN DE 12 8 77 5 70 5 41 1 10 10 38 3.8 SECOND CLASS
HONOURS UPPER DIVISION
3 UJ/SS/102 BARBARA TIVPINE DE 12 8 45 2 40 1 67 4 31 0 12 9 22 1.83 RPT -
ACC 111
4 UJ/SS/103 MONICA LEWINSKY DE 12 8 55 3 32 0 23 0 23 0 12 4 12 1 RPT - BUS
222 BUS 333 ACC 111
5 UJ/SS/104 OLUSEGUN
OBASANJO UME 12 6 40 1 79 5 55 3 40 1 12 12 26 2.17 THIRD CLASS HONOURS
6 UJ/SS/105 GEORGE BUSH UME 12 6 ABS 0 80 5 25 0 23 0 12 2 10 0.83 RPT - BUS
111 BUS 333 ACC 111
7 UJ/SS/106 BILL CLINTON UME 12 6 80 5 81 5 26 0 46 2 12 9 36 3 RPT - BUS
333
8 UJ/SS/107 EINSTEIN UME 12 6 77 5 88 5 99 5 76 5 12 12 60 5 FIRST CLASS
HONOURS
9 UJ/SS/108 TONY BLAIR UME 12 6 44 1 78 5 44 1 48 2 12 12 23 1.92 THIRD
CLASS HONOURS
10 UJ/SS/109 MUSHARRAF O UME 12 6 65 4 ABS 0 49 2 9 7 22 2.44 RPT - BUS
222
11 UJ/SS/110 HI BABY UME 12 6 65 4 ABS 0 44 1 ABS 0 12 7 19 1.58 RPT - BUS
222 ACC 111
12 UJ/SS/111 WET LOOKS UME 12 6 42 1 31 0 31 0 21 0 12 4 4 0.33 RPT - BUS
222 BUS 333 ACC 111
11 UJ/SS/112 DRY LOOKS UME 12 6 88 5 50 3 75 5 55 3 12 12 50 4.17 SECOND
CLASS HONOURS UPPER DIVISION

These could easily be as long as 60 columns.

Thanks,

Tivpine






"rjamison" wrote:

typo:


...length of 5489:

should read
length of 5849

Peter T