Forum Discussion
Decimals
Ok, all I need is a formula on how to calculate ONLY decimals in a number. For example, 1.45 + 3.34. I need to know what .45 + .34 in that equation adds up too. I don't want the whole number on the l...
So this here is what I'm working on. I want the Total Used to be able to change daily and not at the end of the week like I currently have it. The numbers that are to the right of it is how much I've used of said material at work, I just minused Monday's count with (If Worked Saturday). As I've mentioned before though, I want that number to change daily since those numbers will change everyday.
Hopefully this makes sense.
I'm afraid I don't follow. I can see the total used is Monday - If Worked Saturday, and I think you want the total to be Monday minus whatever the last value is in the column (from Tuesday through "if worked Saturday").
But, I've no idea where you are 'just adding the decimals'. Are you sure the actual cell values are to two decimals? If you change the format to increase the number of decimals, is the value actually to a higher precision than displayed?
If the workbook does not contain sensitive data or if the sensitive information can be deleted, can you upload it (hit 'reply' instead of 'quick reply' and you should see an upload link)?
But, I've no idea where you are 'just adding the decimals'. Are you sure the actual cell values are to two decimals? If you change the format to increase the number of decimals, is the value actually to a higher precision than displayed?
If the workbook does not contain sensitive data or if the sensitive information can be deleted, can you upload it (hit 'reply' instead of 'quick reply' and you should see an upload link)?