Help add on this formula!!
 

=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!!

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!!

Hi
do you mean:

--
Regards
Frank Kabel
Frankfurt, Germany

"Slumbering Gorilla"
schrieb im Newsbeitrag
...
=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!!

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

--
Regards
Frank Kabel
Frankfurt, Germany

"Slumbering Gorilla"
schrieb im Newsbeitrag
...
=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!!

One way

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

Regards,

Peo Sjoblom


"Slumbering Gorilla" wrote:

=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!!

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!!