Excel Extending Equations
- by Richard
So I have an excel table that is multiply 1 value against several other values. It looks like this:
So I want the equations inside cells C14 to F14 to be B14*C5, B14*C6, B14*C7, B14*C8 respectively. So I can obviously do that manually but I want to learn the faster way. So I know I should use absolute reference for B14, so I can input =$B$14*C5…