Check if rounded cell values fall within a range

V

vertigo

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

Gunnar Lysaker

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

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

G.
 
D

Dennis from Suffolk

This is a fairly conventional way for checking values within a range:

=IF(AND(P928>0.5,P928<=1),"Normal Criteria","")

In this example, P928 would be changed to your particular cell reference.
If the test evaluates to false, you can choose a different action than I have
posed, which is do nothing.
 
Top