Hi Everybody,

How do I write a formula to do the following?

If another cell's value is greater than 0.5 but less than or equal to 1 then
set the value of this cell to "Normal Criteria"?

I'll appreciate it very much if anybody can help - my problem lies with the
fact that there are two conditions to check and I don't know the correct
syntax.

Appreciate it.