ExcelBanter - Use of "AND"

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

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

- - Use of "AND" (https://www.excelbanter.com/excel-worksheet-functions/257149-use.html)

Wally

Use of "AND"

How do i use "AND" in an if statement on Excel worksheet?

Eduardo

Use of "AND"

Hi,
when you want to meet two conditions for example
A1= 2
A2= 3

if the conditions above are true you want to result be "OK" otherwise "WRONG"

=if(and(A1=2,A2=3),"OK","WRONG")

"Wally" wrote:

How do i use "AND" in an if statement on Excel worksheet?

Pete_UK

Use of "AND"

Here's an example:

=IF(AND(A10,B10),"Positive","not valid")

Both A1 and B1 have to be greater than 0 to get "positive".

Hope this helps.

Pete

On Feb 23, 6:47*pm, Wally wrote:
How do i use "AND" in an if statement on Excel worksheet?

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