View Single Post
  #1   Report Post  
Slumbering Gorilla
 
Posts: n/a
Default 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!!