showing only 0s after decimal...not true numbers

[pipsissewa]

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!

[SpoonMan22]

I think that the workbook I have included will help with this.

Instead of using quotient which I believe onyl returns the integer value (Whole number) I have just divided by the number of lines on a page.

First take the number of words you have. e.g 5000.

Divide by number of lines per page e.g 65

And multiply by amount you are paid e.g. $0.10

The formula becomes

=(5000/65)*0.10
=$7.69

Where quotient would have returned a value of 76 for lines and therefore only 7.60 for payment.

[pipsissewa]

SpoonMan - Thanks for your help! Unfortunately, I need all of the columns showing the characters, lines, and then total...I can't just put the whole formula in one column. I know it can be done, as I have a worksheet set up like that already; however, it's protected and I can't make changes (the change I need is to change the amount I get paid per line).

[SpoonMan22]

If you look at the worksheet that I provided I have it broken into columns by A=Number of Characters, B=Line Count,and C=Payment
On the side I included a small table where you can set the number of character in a line, and then another cell where you can set the price.
In Column A you input the number of characters in the document

In Column B The number of lines is calculated based upon your preset characters per page (You mentioned 65 in your question)

And then in Column C the number of lines is multiplied by your set rate of payment.


Maybe I am missing what you are looking for entirely.

If anything sorry I couldn't help more.

SpnMan

[pipsissewa]

Ok - I see what you did! I apologize, it's been a crazy couple of weeks and my brain is fried. I tried doing what you did in your worksheet, but it's doing the same thing...in your worksheet, with the character count of 6200, the line count is 95.3846...in my worksheet, doing what I think is the same thing, the line count is 95.0000...I just can't get those 0s to be the right numbers...I've attached the worksheet that I am having problems with.

Again, sorry for the confusion on my part, and thank you for your help!

[SpoonMan22]

Its because you are still using the quotient function, which takes whole numbers. Change the content of cell F17 on your sheet to

Please Login or Register  to view this content.

Should solve your problem

[SpoonMan22]

sorry the quotient fuction returns a whole number. all you need to do is divide

[pipsissewa]

Oh my goodness. I feel like a fool, but you've just made my week!!! Thank you so much!!!

[SpoonMan22]

No problem, glad to help