Show as blank rather than 0.00% (Decimal showing as %)

Question

How can I set the calculated formula on SharePoint list when the result is 0 (0.00%) to show as a blank and if there is a value do the following calculation =Figure/100?

Hope you can help me.

Answer 1

Try using calculated column formula like this:

=IF(ISBLANK([Figure]),"",[Figure]/100)

Notes:

1. Sometimes comma(,) does not work in formula (it is based on language or regional settings on your site). So in that case use semicolon(;) instead of comma(,).
2. Use correct display name of your SharePoint columns in above formula.
3. Wrap column names inside [] if your column name has space in it. For example: [My Column Name].