IF formula using a range of values in a cell

[Baz]

I want to write a formula that gives a result in a cell if the value in the
target cell has a range of values. (i.e.) something like
IF (value in cell A3 has a value of >80 but <85, put a figure (e.g.) 3 in
the result cell or otherwise a zero.
Any help would be appreciated. Thanks in advance.

 

[Gary]

=IF(AND(A3>80,A3<85),3,"")

 

[Pete_UK]

Or even:

=IF(AND(A3>80,A3<85),3,0)

Pete

=IF(AND(A3>80,A3<85),3,"")






- Show quoted text -

 

[Max]

One way
In say, B3: =IF(AND(A3>80,A3<85),3,0)

 

[Stefi]

=IF(AND(A3>80,A3<85),3,0)
Regards,
Stefi


„Baz†ezt írta:

 

[Mike H]

Perhaps

=IF(AND(A3>=80,A3<=85),3,0)

Mike

 

[Baz]

--
Baz Oz

=IF(AND(A3>80,A3<85),3,"")




Thanks for help - I appreciate it. Baz

 

[Teethless mama]

=(A3>80)*(A3<85)*3