ExcelBanter - If funtion in Excel

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

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

- - If funtion in Excel (https://www.excelbanter.com/excel-worksheet-functions/142039-if-funtion-excel.html)

amoreena

If funtion in Excel

Looking to creat If function to match this formula

if x is -2 and < 2 then Pass

Teethless mama

If funtion in Excel

=IF(AND(A1-2,A1<2),"Pass","")

"amoreena" wrote:

Looking to creat If function to match this formula

if x is -2 and < 2 then Pass

MyVeryOwnSelf

If funtion in Excel

Looking to creat If function to match this formula

if x is -2 and < 2 then Pass

One way:
=IF(ABS(A1)<2,"Pass","whatever")

Modify to suit.

All times are GMT +1. The time now is 06:32 AM.