Formula Problems

Hi,

The attached workbook needs a few things added/fixed with it.

The workbook has 2 spreadsheets; one called T-Test and the Other Called Z-Test.

In both sheets, there should never be a significance # OR Z-Score displayed without ALL proportions, samples, and standard error #s filled in.

2_Proportion_T&Z_Test_Tool_9.6.2012.xls

Wrap with this function:

Z-test tab:
IF(COUNTBLANK($A7:$F7)>0, " ", stat_function)

T-test tab:
IF(COUNTBLANK($A7:$D7)>0, " ", stat_function)

That should do it.

BTW, your title... I thought this was going to be a question about "Formula Auditing" because your thread title was vague. Can you re-title with something more precise? Thanks.