I have a task on hand and have been struggling to get the right number. Here is what I'm working with..
Part A $63,569.60 <-- my goal to achieve (as close as possible, hopefully within cents).
Part B 277104
My goal is I need to update 277104 units, so that when multiple by a particular number/numbers it will equal the number in Part A. The problem I'm facing is that this is a $ dollar amount, so it cannot be longer than 2 decimal places: such as .23 or .24
Doing this =63569.6/277104 gives me a number .229 - now this creates lots of problems for me because I can't do 3 decimal places, but if I do .22 it is way short and .23 is a little more.
I am okay to multiple some units by .22 and some by .23 as long as they equal the number in Part A. Is there an easy way to calculate this??