|
Erro in Formula, Pleas Help?
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? -- ( ) happy |
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 ..."))))))) "jsc3489" wrote: 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? -- ( ) happy |
I just figured that out, however, I had to write the text in diff cells and
reference to those cells, -- me "bj" wrote: 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 ..."))))))) "jsc3489" wrote: 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? -- ( ) happy |
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.","") "jsc3489" wrote: I just figured that out, however, I had to write the text in diff cells and reference to those cells, -- me "bj" wrote: 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 ..."))))))) "jsc3489" wrote: 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? -- ( ) happy |
| All times are GMT +1. The time now is 08:49 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com