Determine if a number is in a range 1

[bdjb]

Hello,
I'm using Crystal 11. I'm trying to determine if a number is in a range: I have a distance field (say 89 miles), and I need to group by mileage, 50, 100, 150, etc miles. So I'm trying to figure how to write a formula to check that?

Thanks!

 

[Madawc]

Do a formula field,

if isnull({your.milage}) 
then "a) No milage"
else if {your.milage} < 50
then "b) Less than 50"
else if {your.milage} < 1000
then "c) Up to 100"
...

This will sort in order, and could also be used for grouping.



Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[bdjb]

Thank you for that suggestion, it worked quite well. I set the result of the formula as my group.