title: How can use IF & MAX together?
body: <p>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.</p>
  
  <p>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"</p>
  
  <p><a href="https://i.stack.imgur.com/kS9zU.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/kS9zU.jpg" alt="VM"></a></p>
  
  <p>Thanks in advance</p>