How to get the result with IF function

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Leng - 08 May 2008 02:52 GMT

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

Reply to this Message

T. Valko - 08 May 2008 03:06 GMT

Try this:

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

Signature

Biff
Microsoft Excel MVP

> Hi,
>
[quoted text clipped - 6 lines]
>
> Thanks

Reply to this Message

Dave - 08 May 2008 03:27 GMT

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

> Hi,
>
[quoted text clipped - 6 lines]
>
> Thanks

Reply to this Message