Variance in a row

Question

How can I get the green highlighted cell to calculate and display the actual difference from the lowest cell value to the highest cell value of the yellow highlighted cells in a particular row?

I have attached a .pdf of a spreadsheet below.

ozderf · Answer

The value in the .pdf was entered manually. I would like to format the cell to do it automatically.

oliverscheurich · Answer

Ozderf&nbsp;Do you want to calculate the difference from B10:K10?=MAX(B10:K10)-MIN(B10:K10)This can be done with above formula. However i haven't seen the yellow highlighted cells in the spreadsheet (except for cells R8 and R9).