Formula returning 0 or dash when i add a number

Copper Contributor

not sure whats wrong this a sheet i use to keep track of pay

6 Replies


I cannot see anything that illustrates the problem in the screenshots.

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?

Please indicate where the formula returns an incorrect value in your opinion.

can i email you the file to see?
Better to attach the file to your post or share via onedrive or dropbox link here in comment.


If you'd rather not upload the file to a cloud storage service, you can attach it to a private message to me (click on my user picture)

@HansVogelaar thank you for the help.  I ended up just having to clear the cell and re input the formula and it worked very weird.


All's well that ends well...