A new equation problem

[stryder09]

Okay I have to build an equation that if it is between 3 different variables to return a certain demerit point.

If [Top/BottomWTSplitBisectedMeasured]>0.48 but <0.5201 Then return a value of 0
If [Top/BottomWTSplitBisectedMeasured]>0.47 but <0.5301 Then return a value of 2
If [Top/BottomWTSplitBisectedMeasured]>0.45 but <0.55 Then return a value of 5
If [Top/BottomWTSplitBisectedMeasured]>0.55 but <0.45 Then return a value of 20.

Any help would be appreciated thank you.

Brad

[pbaldy]

I'd love to see the number that is ">0.55 but <0.45".

Take a look at the Switch() function, with tests like

[Top/BottomWTSplitBisectedMeasured]>0.48 AND [Top/BottomWTSplitBisectedMeasured] <0.5201

[stryder09]

Perfect thank you the following worked for me.

=IIf([Top/BottomWTSplitBisectedMeasured]>0.48 And [Top/BottomWTSplitBisectedMeasured]<0.5201,0,IIf([Top/BottomWTSplitBisectedMeasured]>0.47 And [Top/BottomWTSplitBisectedMeasured]<0.5301,2,IIf([Top/BottomWTSplitBisectedMeasured]>0.449 And [Top/BottomWTSplitBisectedMeasured]<0.551,5,20)))