View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
tssgraham tssgraham is offline
external usenet poster
 
Posts: 7
Default =IF(A1=MAX($A$1:$A$3),A1,"") Adapt to use multiple "if" formula's

How can I adapt this formula to allow adding multiple "if" formula's? Example:
=IF(A1=MAX($A$1:$A$3),A1,"") PLUS =IF(B1=MAX($B$1:$B$3),B1,"") PLUS
=IF(C1=MAX($C$1:$C$3),C1,"") ? Thanks everyone - today was the first time
I've ever posted for help - you rock! ;-)