I have several columns on a list that are radio buttons for either "Completed" or "Not Applicable". I need to draw the status of an item based on if those columns have data in them. Someone may choose either option on the radio button, but if all columns have data in them, then I need to have the status set as Complete. I have tried nested IF and ISBLANK formulas and I'm not having much luck. I have this formula working, but it doesn't throw the Complete or Incomplete status, it just gives me Yes or No:
=IF( AND( ISBLANK([COL1])="" ) ,IF( AND( ISBLANK([COL2])="" ) ,"Complete" ,"Incomplete" ) )
Any help would be greatly appreciated!