If Then End If Structure

[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.

 

[Peter R. Fletcher]

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.

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

 

[Peter]

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.

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