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