Try

[=1]0%;[<0](0.0%);"***"

Andrea Jones
www.stratatraining.co.uk
www.wrekinpublishing.com

"michael.beckinsale" wrote:

Hi All,

I am trying to format cells so that if the resultant % is 100% or <
100% then the cell displays *** Negative values need to be shown in
(%) rather than prefixed -

The following works with the exception that it will not display
negative values as (%)

[1]"***";[<-1]"***";0.0%;-

Please can anybody come up with the right syntax?

I need to avoid using IF statements in the formulas

Regards

Michael