10 Replies Latest reply: Apr 12, 2011 9:18 AM by canmarroig RSS

    If then....with negative percentage

    canmarroig

      Good morning, i've different %margin and i want to put a description in order to aggregate negative results, but i've made a mistake:

      =if(%margin<-,50,'lower than -50%',if(%margin<-,30, 'between -50% and -30%',if(%margin<-.99, 'lower than 0', 'more than 1%')

      can you help me?

      Expression tell me that "," is wrong but i live in Italy and this is my metric unit.

      Thank you