# Having formula only calculate using fields of current row

#### smth333

##### New Member
I have a speadsheet where cols. A to N have headers in row 1. These headers are Name, Address etc. Columns D thru N contain values , manually entered for each record, and so can vary, e.g. In Col D ZIP codes are entered. Col G uses a list of values etc. 10 Separate calculations are performed in COL R, e,g R2 is given a valued depending on the value of the ZIP CODE entered in D. R4 is given a value dependent on the value entered in E, R6 calculates a value dependent on the value typed in F etc. I want these values calculated regardless of the row that is populated. By this I mean if I enter the first record, all the data entered will be for Row 2, the formulas correctly calculate the 10 values in Col R for the first record in row 2, however when I enter data for a second record in row 3, or a third record in row 4, the calculations are ignored, and only work for the first recod in row 2. How Can I get COL R (10 separate calculations;formulas) to execute these formulas for the row in which I'm currently entering data. That is if I'm entering data for my fifth record in row 6, I want the values in row 6 used in my formulas, If I'm entering data for my 3rd record in row 4, I want the data in row 4 used in my calculations, etc.

Sid

### Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

#### just_jon

##### Legend
Re: Having formula only calculate using fields of current ro

Something along these lines? [ Assumes the following -- Column D is the triger for changing rows and column D in numeric. If column D is text, change 999999 to REPT("z",255). ]
Book1
DEFGHI
1ZIPCodeValue1Value2Valuexcol-R
299999abc123q2q1368
367564xyz456w3w
Sheet2

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,167,939
Messages
5,856,409
Members
431,812
Latest member
Elastomers

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back