OH MY GOD!!. sorry guys. it was my stupid fault. i just realized i kept
typing mix instead of max. i realized it when i saw that first reply. thanks
guys for helping me to realize my own stupidity.

"Dave R." wrote:

Do you care what happens with negative numbers?

If not you can use

=HLOOKUP(D13,'Hidden Data'!D9:F10,2,0)*MAX(E13,15)



"Slumbering Gorilla" wrote in
message ...
=HLOOKUP(D13,'Hidden Data'!D9:F10,2,0)*E13


ok i want to make so that if the value in E13 is 14 or less, that it would
alwways give 15. so if the value in E13 was anything between 0 and 14, it
would multiply as if it were 15. for some reason i cant get the whole
formula
right.
Need help!!