Count the Difference between the Highest and Lowest Value

Brew

Well-known Member
Joined
Sep 29, 2003
Messages
1,569
How do I express a formula that will count the difference between the lowest and the highest value within 3 cells:

Sample1:

A1:C1=055
Result
D1=5

Sample2:

A2:C2=697
Result
D2=3
 

Some videos you may like

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.

Watch MrExcel Video

Forum statistics

Threads
1,119,265
Messages
5,577,094
Members
412,766
Latest member
BigRusty82
Top