How to get the result with IF function

L

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
 
D

Dave

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