I need Help Multiplying Whole Numbers!!

[tommygunnz]

I'm trying to calculate commissions for my team. They get $100 per unit sold once they hit 9. But if its a half deal (.5) they do not get $50 instead. Only on full deals.

example: 1-8 deals = 0 bonus
9 deals = $900
9.5 deals = $900
10 deals=$1000 and so on

but with my formula 9.5 deals= $950 !!???!! How can I tweak my formula to only multiply the whole number?

so my current formula is =(D31>=9)*(D31*100)

 

[Joe4]

Welcome to the Board!

Try:

[COLOR=#000000][FONT=Inconsolata]=[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata]([/FONT][/COLOR][COLOR=#F7981D][FONT=Inconsolata]D31[/FONT][/COLOR][FONT=Inconsolata][COLOR=#000000]>=[/COLOR][COLOR=#1155cc]9[/COLOR][/FONT][COLOR=#000000][FONT=Inconsolata])[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata]*[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata](INT([/FONT][/COLOR][COLOR=#F7981D][FONT=Inconsolata]D31)[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata]*[/FONT][/COLOR][COLOR=#1155CC][FONT=Inconsolata]100[/FONT][/COLOR][COLOR=#000000][FONT=Inconsolata])[/FONT][/COLOR]

 

[tommygunnz]

Wow 1 reply and you got it!! Thanks so much. This forum is awesome. Thank you!!

 

[Joe4]

You are welcome!

Yes, the INT function just takes the Integer value of a number, meaning it just drops the decimals.

 

[tommygunnz]

You are welcome!

Yes, the INT function just takes the Integer value of a number, meaning it just drops the decimals.

One more Question. if the sell 5 used units, they get a flat $500 bonus. how can I write that?

=(D29=>5)+(500) ?? not working for me

 

[Gerald Higgins]

The OP said if they sell 0-8 units, they get nothing.

It seems like the bonus structure is actually more complicated than you first described.

Let's assume they get nothing for 0-4.9 units, $500 for 5-8.9 units, and $100 per each whole unit for 9 or more.

Try this

=if(D29>=9,int(D29*100),if(D29>=5,500,0))

 

[tommygunnz]

No the first one worked absolutely perfect!

this is another structure for a different department. if they sell minimum 5 used units they get a flat $500 if they sell 100 used they still get $500

 

[tommygunnz]

so how can I write D29 ( which is used total sales) is => than 5 units, they get a flat $500

 

[Gerald Higgins]

Sorry, your requests aren't clear at all, to me at least.

If you're saying, IF they sell more than 5, then they just get $500, and they get exactly $500 whether they sell 5 units or 50 units, try . . .

=(D29>=5)*500

 

[Joe4]

One more Question. if the sell 5 used units, they get a flat $500 bonus. how can I write that?

=(D29=>5)+(500) ?? not working for me

Just use the same format you used in your first one, i.e.

[COLOR=#333333]=(D29=>5)*500[/COLOR]