How to Blank Table Cells with Small Values

Introduction

This article describes how to go from a standard table...

...to a table where cells with a value under a specified threshold (e.g. 10%) are made blank:

1. Select your table.

2. In the toolbar go to Automate > Browse Online Library > Modify Cell Content > Blank Cells with Small Values.

3. Select the appropriate statistic (if different to the default) to base the condition on.

4. Select the appropriate threshold under Minimum Value.

5. By default, Also set values of statistic to NaN is ticked to set blank cells to NaN.

6. Press OK.

Note, a footer note is also added which specifies this condition.