Help add on this formula!!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

=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)
 
One way

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

Regards,

Peo Sjoblom
 
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.
 
You must log in or register to reply here.

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
need help with formula lookups 2
Help with formula 1
Fill a cell based on a condition being met 3
Help with simple formula 1
Is there any function wich returns a range as text? 2
Nested Formula Giving Incorrect Answer 4
Formula omits adjacent cells error message 4

Back
Top