Hi,

I have the following values and text, and although I've managed to add the values in my text, I don't know how to show only 2 decimals.

This is my formula:

="The owner can be "&H12*100&"% sure that the population proportion (% of customers excited about the new product) is between "&H18*100&"% and "&H19*100&"%"

These are the values

0.95
0.050
0.025
1.960
0.019
0.037
0.653
0.727

and this is the resulted text:

The owner can be 95% sure that the population proportion (% of customers excited about the new product) is between 65.2993513141917% and 72.7006486858083%
The margin of error is 3.70064868580828
If 100 similar intervals were constructed about 99 intervals could contain the population proportion


Thanks in advance.