Importing excel IF/And statments to Smartsheets

1996mustang
1996mustang ✭✭
edited 12/09/19 in Smartsheet Basics

I use the below IF/AND statement in excel.  It works fine. 

=IF(O4="Close","",IF(D4="","",IF(AND(M4>0,M4<=0.1),"YELLOW",IF(AND(M4<=0,M4>-0.1),"GREEN",IF(M4<-0.1,"PURPLE",IF(M4>0.1,"RED",))))))

When I import it into Smartsheets, the formula is below and doesn't work.  I get #UNPARSEABLE in the cell.  Does anybody know why the formula is not working? 

=IF(Status3="Close","",IF(Budget3="","",IF(AND([Delta Margin]3>0,[Delta Margin]3<=0.1),"YELLOW",IF(AND([Delta Margin]3<=0,[Delta Margin]3>-0.1),"GREEN",IF([Delta Margin]3<-0.1,"PURPLE",IF([Delta Margin]3>0.1,"RED", ))))))

Best Regards, 

 

 

Smartsheets snipit.PNG

Comments