How to use range in if condition

[bushpalaamarnat]

Hi All,

I am trying to use the following equation to get a color if value if between -5% and 5%.

For some reason, it is not working. could any one advise.

IF( $(vAcc) >= -0.05 <= 0.05 , $(vTemplate_GSK_SecondaryColour4_1), $(vTemplate_GSK_SecondaryColour2_1))

[sergio0592]

Hi, try with :

IF( fabs($(vAcc)) <= 0.05 , $(vTemplate_GSK_SecondaryColour4_1), $(vTemplate_GSK_SecondaryColour2_1))

[tresB]

Try like:

IF( $(vAcc) >= -0.05 AND $(vAcc) <= 0.05 , $(vTemplate_GSK_SecondaryColour4_1), $(vTemplate_GSK_SecondaryColour2_1))

[bushpalaamarnat]

it did not work, hence i was contacting the community.

[bushpalaamarnat · Accepted solution]

IF( fabs($(vBias)) <= 0.05 , $(vTemplate_GSK_SecondaryColour4_1), $(vTemplate_GSK_SecondaryColour2_1))