# Simplifying a formula

#### carlleese24

##### Board Regular
Hi

Any help on this would be greatful

does anyone know of a simple way in which to do this formula.

=(ABS(H7-G7)+ABS(H7-G6)+ABS(H7-G5)+ABS(H7-G4)+ABS(H7-G3))/5

### Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

#### Richard Schollar

##### MrExcel MVP
Hi

Here's one wy:
Excel Workbook
GHIJ
39
415
516
63
72105.4
Sheet2
Excel 2010
Cell Formulas
RangeFormula
J7=SUMPRODUCT(ABS(H7-G3:G7))/5

#### carlleese24

##### Board Regular
thankyou it works brilliantly

Replies
2
Views
34
Replies
25
Views
454
Replies
11
Views
273
Replies
8
Views
97
Replies
4
Views
298

1,133,567
Messages
5,659,577
Members
418,509
Latest member
empk

### 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