Try this perhaps:
=IF(B40,5;(IF(B4<1;"1";B4*3)))

IF 0,5 and <1 it gives one otherwise mulitply by 3

G.

"vertigo" wrote:

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.