Excel Function

This should do it:

=IF(A1>100,"Out of Range",IF(A1>30,"HIGH",IF(A1>10,"MED",IF(A1>3,"LOW","Out of Range"))))

Let me know if you have problems.

If your data is in column A then you can paste the following formula where you want the words to appear. An alternative would be to use conditional formatting (Format-Conditional Formatting) and make the actual cells with the values or the text be green or red or what ever color you want.

=IF(AND(3<A1,A1<10),"LOW",IF(AND(10&amp;amp;lt;A1,A1<30),"Medium",IF(AND(30<A1,A1<100),"HIGH","")))

PS. I keep previewing this and it scews up my less than signs --i.e. 10<A1. Try fixing it yourself in Excel and it should work.

Gentelman,

It worked great

I really appreciate your help. Thanks you, and I hope you have a great holiday season.

Take care

I don't know if you've tried this but it's a nice touch:

Select Format/Conditional Formatting.

You'll get a dialog box where you can have the cell change format (change color, font, font color, bold, italic, change borders, etc). You can add up to three format changes. In your case you can select, for example:

• If cell value is between 3 and 10, the cell color is green, font is black, Arial, normal.
• If cell value is between 10 and 30, the cell color is yellow, font is black, Times New Roman, normal.
• If cell value is between 30 and 100, the cell color is red, font is white, Verdana, bold.

I did this for my process monitor at my office. It allows me to watch the different processes around the plant from my office (but not control them), and the color changes instantly alerts me to alarm conditions or changes in the process step. I called it Cheap_HMI.xls. That's right, it's an HMI that uses Excel.

That worked great....thanks