6 Replies Latest reply: May 12, 2016 9:22 AM by Giorgio Taurisano

# Condition If

hello

I have a problem with if condition when i insert a formula,

this is my script

= if(interval([OV_DATA_CONS_RICH-OV_DATA_BOLLA],<-5),'Ritardo',

if(interval([OV_DATA_CONS_RICH-OV_DATA_BOLLA],>=-5),'Puntuale',

if(interval([OV_DATA_CONS_RICH-OV_DATA_BOLLA],''),'Non Consegnato')))

• ###### Re: Condition If

try with this

= if(interval([OV_DATA_CONS_RICH-OV_DATA_BOLLA]),<-5,'Ritardo',

if(interval([OV_DATA_CONS_RICH-OV_DATA_BOLLA]),>=-5,'Puntuale',

if(interval([OV_DATA_CONS_RICH-OV_DATA_BOLLA]),'','Non Consegnato')))

you had the condition evaluation as part of the interval function

• ###### Re: Condition If

try this

= if(interval([OV_DATA_CONS_RICH-OV_DATA_BOLLA])<-5,'Ritardo',

if(interval([OV_DATA_CONS_RICH-OV_DATA_BOLLA])>=-5,'Puntuale',

if(interval([OV_DATA_CONS_RICH-OV_DATA_BOLLA]),'Non Consegnato')))

• ###### Re: Condition If

The use of interval here is redundant, It is a formatting function only and does not affect the calculations. What you require is not entirely clear due to the syntax errors in your expression, but perhaps you need this:

= if([OV_DATA_CONS_RICH-OV_DATA_BOLLA] < -5,'Ritardo',

if([OV_DATA_CONS_RICH-OV_DATA_BOLLA] >= -5,'Puntuale','Non Consegnato'))

• ###### Re: Condition If

Hi,

Check this

= if([OV_DATA_CONS_RICH-OV_DATA_BOLLA]<-5,'Ritardo',

if([OV_DATA_CONS_RICH-OV_DATA_BOLLA]>=-5,'Puntuale',

'Non Consegnato'))

Regards,

Jagan.

• ###### Re: Condition If

what you want to achieve? can you explain the logic?

• ###### Re: Condition If

i found the solution in this way:

=if(OV_DATA_CONS_RICH-OV_DATA_BOLLA<<0, 'Ritardo',if(OV_DATA_CONS_RICH-        OV_DATA_BOLLA>>0,'Puntuale','Non Consegnato'))

the problem was that it read the second incorrectly condition

thank you all