formule bonus with Maximum and minimum get nothing

[Drenthe1993]

First of all sorry for the bad english!

i want to know how to solve my project in Excel open office because i don't get the right formule...

This is what i got. Schermafdruk 2015-01-18 14.33.57.png So now here is the problem that i have to solve. in B10:B14 there are 5 numbers.
the highest one get the bonus off stands in B5 times the highest number. The other numbers get nothing.. does any body know how to solve this formule?

[bebo021999]

Try in E10 to get bonus:

=(B10=MAX($B$10:$B$14))*$B$5

Is it what are you working with?

[Drenthe1993]

Yess that's what i am working with! only if i try your formule and make B10 the highest one but the bonus gets €5 euro and not times the highest one like 30*5 = 150

[oeldere]

@Drente1993

You get better help if you add an example of your excel file, without confidential information on the forum.

Please also add the desired (expected) result.

[bebo021999]

I mean getting bonus only. You can multifly with something as you want.

Also this formula in B10 is dynamic by dragging it down to B11,B12...

[Drenthe1993]

this information is not confidential.. and this is een example off the results without formule
Schermafdruk 2015-01-18 15.41.16.png

[bebo021999]

So in E10 and dragdown:

=(B10=MAX($B$10:$B$14))*$B$5*B10

[Drenthe1993]

it worked!!!!!!! Thanks For Your Help

[oeldere]

@Drenthe,

Maybe I explained it not well enough.

In an excel file forummembers are able to work with.

With an PNG (which you added) we can't work.

So you will be better off adding an excel file.

[Drenthe1993]

okey thanks i will do that for the next time !