Hopefully someone can help me. I have 6 cells that look like:
A B C D E F
10 5 20 10 N/A N/A
and a formula in cell seven that reads:
=(B1+D1+F1) / (A1+C1+E1) -1
The thing is the N/A may be in different cells (in column B on the next line, etc. ) The formula will always be in column 7 and the data will always be in columns 1-6. What I want to do is have the formula treat the N/A as 0. I want N/A in the cells, but I just want the formula to treat the N/A as 0. I was thinking something like =IF(A1=N/A,0,?) I want the ? to equal whatever the number is in the cell is. I don't know--I'm lost. Any help would be greatly appreciated.