help with nesting if and large function

[paula77]

I am trying to find the largest value in a data set, once it is found I need "max" to appear beside the largest value in the adjacent column and min to appear beside the smallest value in the data set. I thought I could nest large and small with if function but it does not seem to be working. Any suggestions?
Thanks in advance

[Rutgers_Excels]

If I understand you correctly, this should work....

=IF(A1=MAX($A$1:$A$9),"MAX",IF(A1=MIN($A$1:$A$9),"MIN",""))

[paula77]

thanks so much