Hello! I am trying to format an invoice to use for my business. I get paid per line that I type, so I have it set up where I can input the number of characters I type in a document, and in the next column over it divides that number by 65 in order to get the line count. The next column over multiplies that by the amount I get paid per line, with the totals added up for each at the bottom. The formula I am using to convert the number of characters I type to lines is: =QUOTIENT(Table3[[#This Row],[Ch.]],65)
My problem is that the number that's showing up has the correct number of places after the decimal but they are all showing up as 0. I have tried formatting using a custom 0.###, number with 3 decimal places, etc, but I can't seem to fix this and it's shortchanging me at least $0.10 per document I type, which can add up to be a lot in the long run.
If someone could help me with this, I would be very grateful.
Thanks for your time!
Bookmarks