Help add on this formula!!

  • Thread starter Slumbering Gorilla
  • Start date
S

Slumbering Gorilla

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

Dave R.

Do you care what happens with negative numbers?

If not you can use

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

Peo Sjoblom

One way

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

Regards,

Peo Sjoblom
 
S

Slumbering Gorilla

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF AND VLOOKUP formula needed 1
A total Formula (Help) 2
need help with formula lookups 2
Nested Formula Giving Incorrect Answer 4
Help with formula 1
Fill a cell based on a condition being met 3
formula references vertical cells in a separate worksheet 3
Help with simple formula 0

Top