How to get the result with IF function

[Leng]

Hi,

Kindly advise how to get the result in return with the following condition

A B
12 10

B value must be =>1 but =< 15 will be result A value, otherwise 0.

Thanks

 

[T. Valko]

Try this:

=AND(B1>=1,B1<=15)*A1

 

[Dave]

Hi,
Assuming A is Cell A1 and B is cell B1
=IF(AND(B1>=1,B1<=15),A1,0)
Regards - Dave