Greater than and less than

[bobbydave]

if([Case Type] = 'CFIN' and [Recd To Close] >5<=10,1)                  as [SLA CFIN <= 10 Days],

Is there a way of writing the above statement, it seems that the greater and less than expression gives me an error.

Any ideas?

[trdandamudi]

May be as below:

if([Case Type] = 'CFIN',If([Recd To Close] >5 And [Recd To Close]<=10,1))    as [SLA CFIN <= 10 Days],

[sunny_talwar · Accepted solution]

Try this

if([Case Type] = 'CFIN' and [Recd To Close] >5 and [Recd To Close] <=10, 1)                  as [SLA CFIN <= 10 Days],

[bobbydave]

Ah, just separate them. Simple as.

Thanks