vendredi 1 décembre 2017

How can use IF & MAX together?

How do I perform the following function in Excel? Currently Column C display the MAX value of D4:F4. However I need it to display an alternate value.

For instance if MAX Value is from column D, it'll display "TRAN", or if MAX value value comes from column E, It'll display "VERT" and lastly if it comes from column F, it'll display "LONG"

VM

Thanks in advance

Aucun commentaire:

Enregistrer un commentaire