How will you use absolute cell referencing to compare the increase in salaries of ten employees if the percentage of increase is 10%, 20% and 30%?
Answers
Answered by
0
Answer:
assume the column in which you have written the salaries is A and that is there principal amount
let the increase of particular person be in column B
and write 100 in some other cell suppose h1
so use dollar sign
like this : = ($B1 / $A1) * $H$1
now select the cell and by keeping your curser on + that comes on side and extend down the length till wherever you want and then you can get your answer
Explanation:
Similar questions