View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JaB JaB is offline
external usenet poster
 
Posts: 23
Default Formula too long

Good afternoon

Does anyone have any ideas on shortening the formula below - its apparently
too long (its looking thru a range of cells on different sheets for a
specific value).

=IF('Assessment 1'!M12*'Assessment 2'!M12*'Assessment 3'!M12*'Assessment
1'!M14*'Assessment 2'!M14*'Assessment 3'!M14*'Assessment 1'!M19*'Assessment
2'!M19*'Assessment 3'!M19*'Assessment 1'!M21*'Assessment 2'!M21*'Assessment
3'!M21*'Assessment 1'!M23*'Assessment 2'!M23*'Assessment 3'!M23*'Assessment
1'!M28*'Assessment 2'!M28*'Assessment 3'!M28*'Assessment 1'!M30*'Assessment
2'!M30*'Assessment 3'!M30*'Assessment 1'!M32*'Assessment 2'!M32*'Assessment
3'!M32*'Assessment 1'!M37*'Assessment 2'!M37*'Assessment 3'!M37*'Assessment
1'!M39*'Assessment 2'!M39*'Assessment 3'!M39*'Assessment 1'!M41*'Assessment
2'!M41*'Assessment 3'!M41*'Assessment 1'!M46*'Assessment 2'!M46*'Assessment
3'!M46*'Assessment 1'!M48*'Assessment 2'!M48*'Assessment 3'!M48*'Assessment
1'!M50*'Assessment 2'!M50*'Assessment 3'!M50*'Assessment 1'!M55*'Assessment
2'!M55*'Assessment 3'!M55*'Assessment 1'!M57*'Assessment 2'!M57*'Assessment
3'!M57*'Assessment 1'!M59*'Assessment 2'!M59*'Assessment 3'!M59*'Assessment
1'!M64*'Assessment 2'!M64*'Assessment 3'!M64*'Assessment 1'!M66*'Assessment
2'!M66*'Assessment 3'!M66*'Assessment 1'!M68*'Assessment 2'!M68*'Assessment
3'!M68=0,"Fail","Pass")

Thanks