Nested 'If' functions

[Eve333]

Hi,
I have 3 columns with numerical results and need to compare those and have the highest value in fourth column as a result. I've done it with Nested if statements but I must have missed something since its not working correctly.

Columns: AE (3 months average), AF (6 months average), AG (12 months average)
Column AH-result of comparison =IF(AE2>AF2,AE2,IF(AE2>AG2,AE2,IF(AF2>AE2,AF2,IF(AF2>AG2,AF2,IF(AG2>AE2,AG2,IF(AG2>AF2,AG2))))))
results in column AH are correct when AE or AF is highest but if AG is the highest it brings back AF.

Please can you help.
Tahnks,Eve

 

[jimrward]

have you checked out the MAX function