| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I want result of a function in the cell and not the function itsel | Excel Worksheet Functions | |||
| Can not get function result | Excel Discussion (Misc queries) | |||
| FV Function result is unexpected. | Excel Worksheet Functions | |||
| Value or function as result.... | Excel Worksheet Functions | |||
| function based on result of same function | Excel Discussion (Misc queries) | |||
Linear Mode
