If condition

[anto1510]

Hi All,
I need help to figure this out.
Sales Made Weightage
>25 15%
16 to 25 12 to 14.5%
11 to 15 7% to 10%
5 to 10 1% to 5%
0 to 4 0%

I am trying to calculate there performance depending on their sales.
If an agent made 16 sales he should get 12 points.
If an agent make sales between 16 to 25 then it should be prorated between 12 to14.5 points.

[scottylad2]

I'm not really clear from your example what your trying to acheive, what do you mean someone would recieve 12 14.5 points prorated? if someon had sales of 18 or 20 what would your expected answer be? maybe you could alter the example to show a little clearer what your input would be to get your desired output

[mrice]

Try this user defined function

Please Login or Register  to view this content.

[anto1510]

I dont want to use VBA. Do we have any other way to figure this out.

[NBVC]

You can use mrices case statements and make a nested IF function...

[anto1510]

Please dont get me wronk.I dont want to use VBA or Macros.

[NBVC]

My suggestion was to transform this:

Please Login or Register  to view this content.

into this:

Please Login or Register  to view this content.

which is a formula!

[NBVC]

My suggestion was to transform this:

Please Login or Register  to view this content.

into this:

Please Login or Register  to view this content.

which is a formula!

[anto1510]

Thank you so much