Can't piece these 3 formulas into 1 cell, how?

[Mathman]

Hi


I can't get this to work into 1 cell. Here are the 3 parts.


MAX(A572:A591)-MIN(A572:A591)
(A572)-MAX(A572:A591)


then I want to divide both like this

(A572)-MAX(A572:A591)/

MAX(A572:A591)-MIN(A572:A591)​

​

​

​

What am I missing, any suggestions?​

​

​

​

Thx! ​

​

​

 

[RedWolf3x]

Try : ((A572)-MAX(A572:A591))/(MAX(A572:A591)-MIN(A572:A591))​

​

​

​

 

[Mathman]

Perfect!

Thank you

 

[Mathman]

I can't get this one to work, what am I missing?


=MIN((A373:A392)-(A373))/(MAX(A373:A392)-MIN(A373:A392))​

 

[RedWolf3x]

Maybe you were trying

=(MIN(A373:A392)-(A373))/(MAX(A373:A392)-MIN(A373:A392))