How to add bonus of Ru 5000 to all salary without using any Formula in excel
Автор: @ADY EDUCATION
Загружено: 2025-09-17
Просмотров: 1066
Описание:
To add a flat bonus of Rs. 5,000 to all salaries in Excel without using a formula, you can use the Paste Special feature: Copy the number 5000, then paste it to the cell containing each salary using the "Add" option under Paste Special.
Here are the step-by-step instructions:
Enter the bonus amount in a blank cell: Type 5000 into any empty cell in your Excel sheet.
Copy the bonus amount: Click on the cell you just typed 5000 into and press Ctrl+C (or right-click and select "Copy").
Select the salaries: Select the range of cells containing all the salaries to which you want to add the bonus.
Open Paste Special: Right-click on the selected cells and choose Paste Special.
Choose "Add" and "Values": In the Paste Special dialog box, under the "Operation" section, select the Add option. Then, under the "Paste" section, make sure Values is selected.
Confirm the action: Click OK.
Employees BONUS CALCULATION in Excel | MUKUL JAIN
How to Calculate Sales Team's Incentive in Excel
Повторяем попытку...
Доступные форматы для скачивания:
Скачать видео
-
Информация по загрузке: