Hm - it would seem that the problem is stemming from the value being stored as 'xxdots' rather than simply 'xx' - Because of this, each field can't appropriately calculate the required values. I've thought of two possible solutions for this problem:
1. Remove the extra characters from the end of the string. Ie. rather than 'xxdots', simply use 'xx'. You won't be able to have the text displayed with the fill-in-the-blank item; however you'll be able to properly save the value, and the value alone.
2. Change the way the other excel fields parse each variable. The current equation for B6 is as followed:
Code:
=IF(B2>B5,(100-(((B2-B5)/B5)*100)),(100-((B5-B2)/B5)*100))
If B2's value read 23dots, the equation above would fail. To overcome this, you could swap each B2 variable with the following:
This syntax will parse the value in the B2 cell, convert this parsed value to an integer, and then use the converted integer in the equation. The original equation would then look like:
Code:
=IF(INT(MID(B2,1,2))>B5,(100-(((INT(MID(B2,1,2))-B5)/B5)*100)),(100-((B5-INT(MID(B2,1,2)))/B5)*100))
You'll need to do this for each 'est' variable.
Does this help solve the problem? Please let me know if you have any additional questions or if I can help in any way.