Forum Discussion
Formula assistance needed
I am working on a workbook and have a WORKING =IF formula, but, AFTER a certain number of rows it spits out a #NAME error, but, I have no misspellings in the formula as it has worked for the previous...
Attach a sample file. Your formula looks fine. You may have different data type like numbers stored as text or white space before or after data. These may cause error.