Is it not just...

=MAX(Range)

for max and

=MIN(Range)

for min?

paula wrote:
I have a data set and need to find the largest and smallest value, and
place max/min beside those values in the adjacent column. These values
need to be able to change if the values in the data set change. I
thought to use the if function and nest the large and small function
within it, but it does not seem to be working. Please help