Quote:
Phoenix-D said:
The final forumla, or one way of doing it, looks like this:
0 - iif([%Range%] < 30, 10, iif([%Range%] < 60, 20, iif([%Range%] < 80, (30 + ([%Range%] - 60)), (50 + (([%Range%] - 80) * 2)))))
|
In the case of the example I gave below couldn’t I do something like:
0- iif ([%Range%] <30, 10, iif ([%Range%] <60, 20, iif ([%Range%] <70, 30, iif ([%Range%] <80, 40, iif ([%Range%] <90, 50, iif ([%Range%] <100, 70, iif ([%Range%] <110, 90)))))))