ExcelBanter - How to get the result with IF function

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How to get the result with IF function (https://www.excelbanter.com/excel-worksheet-functions/186602-how-get-result-if-function.html)

Leng

How to get the result with IF function

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

How to get the result with IF function

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

Dave

How to get the result with IF function

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

All times are GMT +1. The time now is 05:46 PM.