View Single Post
  #5   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

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