Erro in Formula, Pleas Help?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

The following are in cells H98 - h104:

=IF(LEN(C81)>63,"1","0")
=IF(LEN(C82)>63,"1","0")
=IF(LEN(C83)>63,"1","0")
=IF(LEN(C84)>63,"1","0")
=IF(LEN(C85)>63,"1","0")
=IF(LEN(C86)>63,"1","0")
=IF(LEN(C87)>63,"1","0")
=IF(LEN(C88)>63,"1","0")
=IF(LEN(C89)>63,"1","0")
=IF(LEN(C90)>63,"1","0")


=IF(VALUE(H98=1,"You have exceeded the alotted 63 character text in line 1.
You may have no more than 63 characters in the above
space(s).",IF(VALUE(H99=1,"Sorry, you have exceeded the alotted text in line
2. You may have no more than 63 characters in the above
space(s).",IF(VALUE(H100=1,"Sorry, you have exceeded the alotted text in line
3. You may have no more than 63 characters in the above
space(s).",IF(VALUE(H101=1,"Sorry, you have exceeded the alotted text in line
4. You may have no more than 63 characters in the above
space(s).",IF(VALUE(H102=1,"Sorry, you have exceeded the alotted text in line
5. You may have no more than 63 characters in the above
space(s).",IF(VALUE(H103=1,"Sorry, you have exceeded the alotted text in line
6. You may have no more than 63 characters in the above
space(s).",IF(VALUE(H104=1,"Sorry, you have exceeded the alotted text in line
7. You may have no more than 63 characters in the above space(s).","
"))))))))))))))

I have followed the example given in help. What am I doing wrong?
 
you have end parenthesis in the wrong location in all of your if statements.
you have
=IF(VALUE(H98=1,"You ..."))))))))))))))
it should be
=IF(VALUE(H98)=1,"You ...")))))))
 
I just figured that out, however, I had to write the text in diff cells and
reference to those cells,
 
another way to do it would have been
=if(max(H98:H104)>0,"Sorry,you have exceeded the allotted 863 Character Text
in line "&(match(1,H98:H104)-97)&". you may have no more than 63 characters
in the above spaces.","")
 
Back
Top