sumifs how to fill in the data correctly

so I'm having problems figuring what function I need to use and how to insert my info properly to get the answer. below is a sample of my data. And I need to create a formula that will give the customer a rebate of 2% of the sales amount, only if the customer's sales are greater than $10000.
Customer Name Type Sales Rebate
Abidi, Azhar Personal 19535
Angelini, Sara Personal 21360
Aubert, Rosemary Corporate 407
D'Chancie, Francois Personal 9929
Fai, Pai Kit Corporate 19373
Fleischer, Paul Personal 4303
Frankel, Valerie Personal 9541

Try

Formula:

Please Login or Register  to view this content.

everything comes up as 0.00 and a circular reference warning comes up.

Originally Posted by FDibbins

Which cell are you putting the formula in?

im submitting it into d2

nope there is just 3 columns filled in and is asking me to fill in column d with my rebates

ya it is... sighs.

oh i think i just got it! thank you for your help!

Originally Posted by FDibbins

Hi and welcome to the forum

Maybe something like this? Assuming your REBATE is in E1, in E2, copied down...

=if(D2>10000,D2*.02,0)

OR if you want the actual amount less the rebate...
=D2*if(D2>10000,0.98,1)

=if(C2>10000,C2*.02,0)

my problem was trying to make this work in the sumifs... how do i know when just to use the if?

ya i'm in my last week of school, they are giving 2 weeks to understand and do all of the excel properly. I'm not a math whiz so understanding word problems to me in the first place confuses me.