Forum Discussion
Formula Error making my head explode!
I have a pretty intricate spreadsheet tracking staffing and OT usage and ONE line has an error code that is throwing off the whole thing! I am banging my head against the desk because I CANNOT find the error. The actual formula is correct and pulling the right answer, but still giving me the error notification in the top of the cell. This is causing the next step in the spreadsheet to also show an error. Anyone that can help a girl out?!?!?
If formula returns right answer and you see green triangle on the top of the cell, it's not necessary an error. It says that could be an error, i.e. number is represented as text, etc. If you'd like to have number as text, just ignore it.
Settings are here
We'd have to see (a copy of) the workbook...
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
