Years ago I used a formula in a spreadsheet which has worked well for me.
I am now trying to rewrite for a new MAC and can't remember how I did it.
Here is a simplified problem:
C1 is going to be the product of A1 times B1.
Easy enough! But without entering that each time, how do I get C20 to show the product of A20 times B20?
There is a method to allow repeating operations through dragging across the range but I can't figure out how!
Any help would be appreciated.