ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   IF (https://www.excelbanter.com/excel-programming/363180-if.html)

Tufail
IF
 
Hello,
Please help me on this matter
IF(A1<0 & A1 -100 ,"A",B")
becarefull first is 0 and second minus -100

Thanks in advance

Ardus Petus
IF
 
=IF(AND(A1<0,AI-100),"A","B")

HTH
--
AP

"Tufail" a écrit dans le message de news:
...
Hello,
Please help me on this matter
IF(A1<0 & A1 -100 ,"A",B")
becarefull first is 0 and second minus -100

Thanks in advance


All times are GMT +1. The time now is 02:34 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com