developerWorks  >  Lotus  >  Forums & community  >  Lotus SmartSuite Forum

Lotus SmartSuite Forum

developerWorks




NA
Christopher McGath 05/16/2012 05:44 PM
1-2-3 9.8 Windows XP


I want to test if a cell contains a zero or NA. When I use the formula @IF(T51=0#OR#@ISNA(T51),1,0) and the cell has an NA, I get NA. Is there any way around this?

Go back