I am trying to figure out a formula for greater than less then in Crystal. Here is what I need not sure how to do it in crystals
If family size="1" and yearly amt <$14000 then "Extremely Low" else
if family size = 1 and yearly amt >14300 <23850 then "Low"
Crystal will not let me use the second line of this formula. It says that I need a then statement between the greater and less sign. Is there another way to write this statement?