IF statement problem

[Paul Mcfarling]

Hi Everyone,

I am trying to formulate the following for my sales team. I have been using an IF statement ( =IF(D10>=3000,"200",IF(D10>=2999,"150",IF(D10>=2600,"100",IF(D10>=100,"100"))))

but I can only get the the calculation to work with 1 and 2. I do not know how to put a range of numbers in.

1. If they get an average sales of up to £2599 then they receive £100 bonus payment
2. If they get an average sale of between £2600 to £2999 they receive £150
3. If the average sale is over £3000 then they will receive £200

Any help for a novice would be appreciated.

 

[architechnid]

I was able to figure it out in the mean time. I was actually closer than I realized. The solution was:

=SUMIF($C$6:$C$1000,J$7,$G$6:$G$1000)

Where C6:C100 is the category range, J7 is what I wanted it to match, and G6:G1000 are the summed values.

 

[gaz_chops]

Glad it's sorted.