Issue with formula's from an outside source
Here's the problem. I have an outside application that is generating data to be imported into excel. I would also like to import a conditional IF calculation at that time and the application can not generate the column or row for the calculation; however since the data is in a CSV format I only figure out the column, but not the row. What I would like to do find a function that I can put into the formula that would append the row to the conditional if. An example follows If (B(Row) = 0,0,A(row)/B(Row)).
|