Try this:

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

--
Biff
Microsoft Excel MVP


"Leng" wrote in message
...
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