IF & "and"
Posted by Mo on February 03, 2001 5:05 AM
I have 5 colums in my spreadsheet. If all these 5 colums are filled in one, then my formulas display one meaning complete. e.g
What I want is to introduce another variable, Non Applicable. So if some columns have 1 and the rest N/A (Non Applicable) then it displays one as well. Basically I want the formulas to interpret N/A as a 1 as well. So if all columns are N/A a one is displayed as well.