V vaxo New Member Feb 10, 2017 #1 hello, nedd to calculate result more easy way with formula thanks in advanced... Attachments high low.xlsx 8.7 KB · Views: 8
Asheesh Excel Ninja Feb 10, 2017 #2 Welcome to the forum... If you combine all your functions together..wouldn't it work MAX(D11:D15)-(MAX(C11:C15)*((MAX(C11:C15)-MIN(C11:C15))/(MAX(D11:D15)-MIN(D11:D15))))
Welcome to the forum... If you combine all your functions together..wouldn't it work MAX(D11:D15)-(MAX(C11:C15)*((MAX(C11:C15)-MIN(C11:C15))/(MAX(D11:D15)-MIN(D11:D15))))
