• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Excel help needed

L

larciel

Diamond Member
Any help will be appreciated.

I'd like to divide rows of cells by certain number K

row A contains variables row B contains below equation

What I did was do =Sum(A1/Z1) where Z1 contains the number K


If I drag to copy, it only does copy first row. i.e. it goes =Sum(B1/??)

I'd like to copy it so that the second variable is fixed at Z1 while first one moves from B1 to B2 to B3 and so on

 
To freeze the reference to Z1, enter it as $Z$1 in your formula. No matter where you copy the formula, the denominator will always be Z1. This is called an absolute reference to Z1.
 
FYI you can use the F4 key when inputting a formula to put those $ 'anchors' in the formula as you enter it
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top