I have in cell D5 .. the letters A1

and I am using =MAX(D5:A3)

But I need the D5 to be "whats in the contents"

so excel sees it as

=Max(A1:A3)

what do I use for this?? $D5? $D$5

I cant remember how to make a cells value be the actual Figure used in the Function.. and not the cell number itself.

Thanks.