8 Replies Latest reply: Sep 15, 2014 3:45 PM by Scott Brier RSS

    Add sign (+/-) using formatting

    Maarten Van Damme

      Hi,

       

      I was wondering if it is possible to add - using formatting options - a leading + or - depending on the value of the number.

      I know one can achieve it like this:

       

      =if(num(5)<0,'-','+') & '5'

       

      which should return "+5".

      (e.g. 5 should ofcourse be a dynamic field).

       

      Thanks!

      Maarten