While the resulting value is correct, it’s not in the right format that you want in the cell.Īnd this has a really easy fix – you just need to change the cell format. or using cell references containing the values to be subtracted. The WORKDAY function returns a date N working days in the future or in the past and you can use it to add or subtract workdays to a given date. Sometimes you’ll notice that after you have subtracted a percentage value from a number, the resulting value isn’t in the proper format (sometimes it shows a percentage value instead of a number). Microsoft Excel provides two functions specially designed for calculating weekdays - WORKDAY and NETWORKDAYS. Converting Percentage Back to General Values In case you do not want this to happen, you can convert the formula into values (i.e., remove the formula and only keep the values). Note that the result of this formula is dynamic, which means that in case you change the Sales value or the Commission percentage value, it would automatically update. In the above formula, instead of calculating the percentage value that we need to multiply with the number, we use the value of the initial sale (in cell B2) and subtract the commission sales value (given by B2*C2) from it. Make sure each of the numbers you enter are in the same column as the main number. To do so, you'll type in a negative version of the number you wish to subtract (e.g., if you wish to subtract 300, type in '-300'). You can also use the below formula: =B2-B2*C2 Enter any subtractions in the cells below. Since 100% is equal to 1, to deduct a specific percentage value from a number, we first calculate the deducted percentage value by subtracting the percentage value from 1, and then multiplying it with the number.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |