I think this is a pretty simple questions.
Let say I have number is column A1-A6 and numbers in B7-B10. I want to divide A1/B7 and a2/B7. If I do the drag down then Excel changes the second number to B8 and then B9. How do I keep this number constant?
Thank you!
Let say I have number is column A1-A6 and numbers in B7-B10. I want to divide A1/B7 and a2/B7. If I do the drag down then Excel changes the second number to B8 and then B9. How do I keep this number constant?
Thank you!