Dear Sir / Madam,
i have a question , i want all digit total of a single cell to a specific number e.g.
i am preparing a proposal for a customer wherein my selling price total should be 9, please see below sample pricing of Gold & Diamond Ring
Gold Value $ 147
Diamond Value $1000
Total Cost $1147 + Labor+mark-up = my actual selling price comes to $ 1286.93 ; but i want to tag it as $ 1287.00.
request you to kindly advise a formula , where in i can get final selling price which has a total 9 as shown above (+1+2+8+7) instead of manual calculation
i have a question , i want all digit total of a single cell to a specific number e.g.
i am preparing a proposal for a customer wherein my selling price total should be 9, please see below sample pricing of Gold & Diamond Ring
Gold Value $ 147
Diamond Value $1000
Total Cost $1147 + Labor+mark-up = my actual selling price comes to $ 1286.93 ; but i want to tag it as $ 1287.00.
request you to kindly advise a formula , where in i can get final selling price which has a total 9 as shown above (+1+2+8+7) instead of manual calculation