Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / May 2008

Tip: Looking for answers? Try searching our database.

MAX TEXT ON A MASSEGE?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Papin - 29 May 2008 21:26 GMT
THIS IS WHAT I'M USING BUT IF I ADD MORE TEXT I GET A ERROR MSSG SAYING I
REACH THE MAX TEXT.

ANY IDEAS?
THANKS

=IF(AND(D9>7499,D12=1,F12<3,P16>2499),"ERES PLATA CON UN FRONTAL AL 25% Y
GENERASTE UN VOLUMEN DE PREMIO DE 2,500 PV O
MAS.",IF(AND(D9>=15000,D12<=0),"ERES RUBY PORQUE GENERASTE 15000 PV EN UN MES
Y NO TIENES",IF(AND(D12=2,F12=6,DATA!F55>3499),"ERES SAFIRO PORQUE GENERASTE
UN PREMIO VOLUMEN DE 3,500 PV O MAS Y TIENES 2 FRONTALES AL 25% POR 6 MESES
DENTRO DEL AÑO FISCAL. ",IF(AND(D9>7499,D12=0,F12<2),"ERES PLATA PORQUE
GENERASTE UN VOLUMEN DE PREMIO DE POR LO MENOS 7,500
PV",IF(AND(D9>=7500,D12<=1,2<F12,F12<6),"ESTAS AL NIVEL DE ORO PORQUE
MANTUVISTES EL NIVEL DEL 25% POR 3 MESES Y CUALIFICAS PARA EL BONO QBI DE
$1,000.00",IF(AND(D9>=7500,D12<=1,5<F12,F12<12),"ESTAS AL NIVEL DE PLATINO
PORQUE MANTUBISTES EL NIVEL DEL 25% POR 6 MESES Y CUALIFICAS PARA EL BONO QBI
DE $5,000.00",""))))))&IF(AND(D9>=7500,D12<=1,F12>11),"ESTAS AL NIVEL DE
PLATINO FUNDADOR PORQUE MANTUVISTES EL NIVEL DEL 25% POR 12 MESES Y
CUALIFICAS PARA EL BONO QBI DE $20,000.00",IF(AND(D12=3,F12<12),"ESTAS AL
NIVEL DE ESMERALDA PORQUE AYUDASTES A 3 FRONTALES A LLEGAR AL
25%",IF(AND(D12=3,F12>=12),"ESTAS AL NIVEL DE ESMERALDA FUNDADOR PORQUE
MANTUVISTE EL NIVEL DE ESMERALDA POR 12 MESES",IF(AND(D12=6,F12<12),"ESTAS AL
NIVEL DE DIAMANTE PORQUE AYUDASTES A 6 FRONTALES A LLEGAR AL
25%",IF(AND(D12=6,F12>11),"ESTAS AL NIVEL DE DIAMANTE FUNDADOR PORQUE
MANTUVISTE EL NIVEL DE DIAMANTE POR 12
MESES","")))))&IF(AND(D9>14999,D12>0,F12>1)," NO ERES RUBY PORQUE TIENES UN
FRONTAL AL 25%",IF(AND(D12=2,F12=1),"ERES PLATA CON DOS FRONTALES AL 25% EN
EL MISMO MES.",""))
Signature

Excel Rocks

David Biddulph - 29 May 2008 21:51 GMT
You're taking up lots of extra space because you are SHOUTING all the time.
Please get your caps lock key repaired.

As you have apparently exceeded (by about 50%) the limit of 1,024 characters
for the length of formula contents, put your text string results in cells
and put the cell references in the formula.
--
David Biddulph

> THIS IS WHAT I'M USING BUT IF I ADD MORE TEXT I GET A ERROR MSSG SAYING I
> REACH THE MAX TEXT.
[quoted text clipped - 32 lines]
> EN
> EL MISMO MES.",""))
Papin - 29 May 2008 22:44 GMT
Sorry about the caps!
Signature

Excel Rocks

> You're taking up lots of extra space because you are SHOUTING all the time.
> Please get your caps lock key repaired.
[quoted text clipped - 41 lines]
> > EN
> > EL MISMO MES.",""))
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.