How to get the result with IF function

TheMSsForum.com: The Microsoft Software Forum

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
Top

Re: How to get the result with IF function by T

T
Wed May 07 21:06:33 CDT 2008

Try this:

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

--
Biff
Microsoft Excel MVP


"Leng" <Leng@discussions.microsoft.com> wrote in message
news:52514866-B7D2-4229-90A6-F0CC86415FD0@microsoft.com...
> 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


Top

RE: How to get the result with IF function by Dave

Dave
Wed May 07 21:27:00 CDT 2008

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

"Leng" wrote:

> 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
Top