| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
|
#4
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
| Simplify formula | Excel Worksheet Functions | |||
| put formula results into a different cell if it is empty | Excel Worksheet Functions | |||
| how do i write a formula and keep in in formula form, so it DOESN. | Excel Discussion (Misc queries) | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Linear Mode
