I would need the formula to work with different selling prices and different percentages. For example: ADD(2,3) will return a value 5. Ways) How to use Excel formulas and functions Computerworld How to Subtract Dates and. If anyone could help with a formula to explain the answer it would be amazing! ADD(value1, value2) where value1 and value2 are the two addend. Is there any function so that I can add one month to given date. Select OK to complete the formula and return to the worksheet. Type a 2 to round the answer to the SUM function to 2 decimal places. Place the cursor in the Numdigits text box. Then when I take 10% off £1.10, which is £0.11p, this returns to £0.99p, which is lower than my original selling price. Type SUM (A2:A4) to enter the SUM function as the Number argument of the ROUND function. Then when this percentage is discounted off the inflated cost, I need the selling total to go back to the original selling price.Ĭustomer A has terms of 10%, so I need to add 10% onto 1.00, which is £1.10. The reason for this is because I sell products at a price, some of my customers have special terms when they purchase so I add a percentage onto the selling price to cover these terms. I am after a formula or an excel formula so I can add a percentage to a number, then when I discount the same percentage off the larger figure I get back to exactly the same figure. I have found similar answers to this question but they don't seem to work.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |