Joined: 17 Mar 2010
Online Status: Offline
Posts: 83
Topic: Ranges in a formula? Posted: 23 Nov 2011 at 4:52am
I have in my database numbers
10 20 30 40 up to 300. I want to do this....
if (database.myfield) is between 10 and 30 then "Great" else if (database.myfield) is between 40 and 100 then "Good" else if (database.myfield) is between 110 and 200 then "Fair" else if (database.myfield) = 210 then "Bad" else if (database.myfield) = 220 then "Terrible" etc
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
