Getting #VALUE! error for Hyperlink Formula

[tinferns]

Below is my formula:
=HYPERLINK("mailto:"&G9&"?subject="&$B$1&TEXT(I9,"Mmm-yyyy")&"&cc="&$B$2&"&body="&P9,"Send email")

G9 - Consists of valid Email address.
B1 - Valid Subject line
I9 - Consists of Date converted in MM-YYYY format
B2 - Valid Email address
P9 - consists of IF formula - which is linked to another cell with HTML tag - ="Hi "&[@[First Name]]&"%0ASharing your QC score for "&TEXT(H9,"Mmm-yy")&"%0A%0AYour score is: "&TEXT(M9,"0.00%")&"%0A%0APlease work towards getting scores of 95% or higher.%0A%0A%0AThanks,%0A%0AMartin"

Is this error due to crossing the 255 character mark? Is there any workaround besides having to reduce the number of words?

 

[Dave Patton]

What is in H9?
Try Excel's Formula Evaluate and ensure the input is correct.

 

[tinferns]

Hi Dave.. thanks for your quick response. H9 - consists of a name. And it is in the correct format. Let me add more info on P9 (I think this is the culprit!)

P9 =IF([@[Accuracy Score]]>=95%,[@Good],[@Bad])

Column Good ="Hi "&[@[First Name]]&"%0ASharing your QC score for "&TEXT(H9,"Mmm-yy")&"%0A%0AYour score is:
"&TEXT(M9,"0.00%")&"%0A%0AGood Job!%0A%0A%0AThanks,%0A%0AMartin"

Column Bad = ="Hi "&[@[First Name]]&"%0ASharing your QC score for "&TEXT(H9,"Mmm-yy")&"%0A%0AYour score is: "&TEXT(M9,"0.00%")&"%0A%0APlease aim for 95% or more.%0A%0A%0AThanks,%0A%0AMartin"

Tried Evaluate.. did not give me a clear understanding. I made a few modifications and now I am NOT getting an error for rows where P9 has picked up GOOD data. If you notice the string is longer in Column Bad than Column Good. If I remove the sentence "Please aim for 95% or more" from Column Bad, the #VALUE! error goes off. Is there any way out?

Please advise.

Thanks.

 

[FormR]

Hi, if this..

=LEN("mailto:"&G9&"?subject="&$B$1&TEXT(I9,"Mmm-yyyy")&"&cc="&$B$2&"&body="&P9)

Returns a number greater than 255 then that is your problem as the length of the "link location" is limited to 255 characters.

 

[tinferns]

Thanks, guys..