ExcelBanter - IF statement...And condition

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - IF statement...And condition (https://www.excelbanter.com/excel-discussion-misc-queries/171667-if-statement-condition.html)

Rich D

IF statement...And condition

Using the IF statement, how do I use more than one criteria to be met? Can I
use an AND in it? that is, =IF(condition 1 AND condition 2,XXX,YYY).
--
Rich D
Armstrong Custom Homes
Redmond

Kevin B

IF statement...And condition

Use the And function as part of the conditional clause

=IF(AND(A1=2,B2=3),XXX,YYY)
--
Kevin Backmann

"Rich D" wrote:

Using the IF statement, how do I use more than one criteria to be met? Can I
use an AND in it? that is, =IF(condition 1 AND condition 2,XXX,YYY).
--
Rich D
Armstrong Custom Homes
Redmond

All times are GMT +1. The time now is 02:35 PM.