Help adding something to my ifferror/Vlookup formula

I have this formula that will draw a certain number out of a table
=IFERROR(VLOOKUP($C$4,$C$20:$L$46,7,False);"")

Now what i would also like my formula to do is be multiplied by 1.5 IF the value in basis!D19= bigger than 2002, other wise the value may remain the same
And if possible i would love it to be round up to a number 5/10/15 etc

I am just here wondering wether this is even possible, so if not please inform me. Any suggestions would be greatly appreciated since this is way beyond my skillset, thanks!

One way:

Formula:

Please Login or Register  to view this content.

This will round up to the nearest 5. If you need something different, i.e. just round up to the next whole number then let us know.

Note you may need to switch commas for semi colons for your version of Excel.

BSB

Thanks a lot, looks good, lets see if i can get it too work!

It (sorta works), but it seems as if even when Basis!D19 is >2002 it will still multiply with 1,5, however my shift ends right now so it might be a few days before i start struggling with this again.
If you maybe know why it does this, great. Otherwise ill try to find out later since i've only had 15 minutes now to look at it.

Anyway, thanks a lot for your effort!!!!

Your original post says:

Originally Posted by The excel apprentice

multiplied by 1.5 IF the value in basis!D19= bigger than 2002, other wise the value may remain the same

and that's what the formula does.

Now you're saying that's not what you need? I'm confused.

BSB

I think i used the wrong symbol in my response, what i meant is that when the value in basis!d19 is below 2002 it will still multiply, while its only suposed to do so when the value is above 2002.

It works for me. See the yellow cell in the attached.

It could be that the rounding is masking the results a little.
Did you want them rounded up to the nearest 5 as per the 5/10/15 example in your original post or just to the next whole number?

BSB

It could be that i made a mistake, because i only spend little time on it before my shift ended. Im currently on my phone so i cant check your attached. And yes i wanted the number rounded to the closed number which is multiplyable by 5. But i think it is best to let it rest untill i am behind my pc so that i can check wether i screwed something up before you start spending too much effort on something you might have nailed in the first instance( allthough i greatly appreciate your effort ofcourse)

I've finally had some time too check your attached, if i put in any value above 2002 it appears to go blank.

However I found out why i didn't work in my sheet, the cell Basis!D9 was set on text and not on numbers. Thank you very much, i've got it working!

Now all I have to do is actually implement it.