6 September, 16:44

# Assume that cell F5 to F10 In a spreadsheet contains numeric value of salary earned by some workers and cell F12 contains the value of 5%. Write a formula that will be used to increase the value stored in the cell F5 by 5%?

+1
Answers (1)
1. 6 September, 17:33
0
=F5*\$F\$12+F5

Explanation:

If we want to increment the salaries in the cell F5, we must multiply the cell F5 by cell F12, and then we must sum that result.

If we want to drag the formula from the cell F5 to F10, we must use the dollar symbol \$ to apply the same percent in our formula.

For example:

F12 = 5% = 0.05

F5 = 10,000

=F5*\$F\$12+F5

=10,000*0.05+10,000 = 10,500
Know the Answer?
Not Sure About the Answer?
Get an answer to your question ✅ “Assume that cell F5 to F10 In a spreadsheet contains numeric value of salary earned by some workers and cell F12 contains the value of 5%. ...” in 📙 Computers & Technology if there is no answer or all answers are wrong, use a search bar and try to find the answer among similar questions.