If Then End If Structure

  • Thread starter Thread starter Peter
  • Start date Start date
P

Peter

I want a calculated field that evaluates the Order price
and puts in "Small" (If < 500), "Medium" (If between 500
and 2500), and "Large" (If > 2500). Any help on the
proper way to structure this would be greatly
appreciated. Thankyou in advance.

Peter.
 
IIF([OrderPrice] < 500, "Small", IIF ([OrderPrice] > 2500, "Large",
"Medium"))

Watch out for the line wrap!

I want a calculated field that evaluates the Order price
and puts in "Small" (If < 500), "Medium" (If between 500
and 2500), and "Large" (If > 2500). Any help on the
proper way to structure this would be greatly
appreciated. Thankyou in advance.

Peter.
Click to expand...


Please respond to the Newsgroup, so that others may benefit from the exchange.
Peter R. Fletcher
 
Thanks alot! it worked great..
-----Original Message-----
IIF([OrderPrice] < 500, "Small", IIF ([OrderPrice] > 2500, "Large",
"Medium"))

Watch out for the line wrap!

I want a calculated field that evaluates the Order price
and puts in "Small" (If < 500), "Medium" (If between 500
and 2500), and "Large" (If > 2500). Any help on the
proper way to structure this would be greatly
appreciated. Thankyou in advance.

Peter.
Click to expand...


Please respond to the Newsgroup, so that others may benefit from the exchange.
Peter R. Fletcher
.
Click to expand...
 
Back
Top