Need help with Formula

[granny1]

Need help to cculate formula assigning values to data. 0-1.5=dissatisfied. 1.5.1 to 2.5(Not up to expectations.)
2.5.1to 3.5 Fair and arrive at an average

 

[theDeej]

Try this...

IF {table.rating} < 1.5
THEN &quot;dissatisfied&quot;
ELSE IF {table.rating} > 1.5 and {table.rating} < 2.5
THEN &quot;Not up to expectations&quot;
ELSE IF {table.rating} > 2.5 and {table.rating} < 3.5
THEN &quot;Fair&quot;

You would then use a summary to average all the responses, and use the same formula to apply &quot;dissatisfied&quot;, etc. to the summary (total average). Just replace &quot;{table.rating}&quot; with your summary field name.

 

[mbarron]

One correct for theDeej's post. You need to add some &quot;=&quot;s to the formula. Without them, results of 1.5, 2.5 and 3.5 will be an empty string.


IF {table.rating} < =1.5
THEN &quot;dissatisfied&quot;
ELSE IF {table.rating} > 1.5 and {table.rating} <=2.5
THEN &quot;Not up to expectations&quot;
ELSE IF {table.rating} > 2.5 and {table.rating} <= 3.5
THEN &quot;Fair&quot; Mike

 

[theDeej]

Yes, that indeed would help!

Thanks Mike for catching that...