Excel formula
 

I'm sure this is an extremely simple question, but I need help with a
formula, hopefully I can explain this in a way that someone can follow: We
give bonuses for the # of loans we process; Each cell has a loan with a
dollar amount, BUT....a cell below that (D23) calculates the total # of JUST
the # of loans (Not the amounts, just the loans, based on how many cells have
entries). I need to create 3 new cells that calculate bonuses on those
loans. 1st cell = if there are 1-4 loans, each loan will get a bonus of
$100, 2nd cell = if there are 5-8 loans then ALL loans will get a bonus of
$150, 3rd cell = if there are 9 or more loans then ALL loans will get a bonus
of $200. Example, if D23 calculates that there are 3 loans, the bonus will
=$300. If D23 calculates that there are 6 loans, the bonus will =$900. If
D23 calculates that there are 9 loans, the bonus will be $1,800. I have
these three cells in one column.
--
Thank you!

Excel formula
 

Sure thing..

1st cell:

=IF(D23<=4,D23*100,"")

2nd:
=IF(AND(E23="",D23<=8,D23*150,"")

3rd:
=IF(D23=9,D23*200,"")

The 2 cells that don't meet the criteria are left blank.

Please note, I assume 1st cell is entered in E23 in that 2nd formula.

"Lighthouseskrapbooker" wrote:

I'm sure this is an extremely simple question, but I need help with a
formula, hopefully I can explain this in a way that someone can follow: We
give bonuses for the # of loans we process; Each cell has a loan with a
dollar amount, BUT....a cell below that (D23) calculates the total # of JUST
the # of loans (Not the amounts, just the loans, based on how many cells have
entries). I need to create 3 new cells that calculate bonuses on those
loans. 1st cell = if there are 1-4 loans, each loan will get a bonus of
$100, 2nd cell = if there are 5-8 loans then ALL loans will get a bonus of
$150, 3rd cell = if there are 9 or more loans then ALL loans will get a bonus
of $200. Example, if D23 calculates that there are 3 loans, the bonus will
=$300. If D23 calculates that there are 6 loans, the bonus will =$900. If
D23 calculates that there are 9 loans, the bonus will be $1,800. I have
these three cells in one column.
--
Thank you!

Excel formula
 

Thank you Sean, but this did not work. Cell #1 is located in D51, Cell #2 is
D52, and cell #3 is D52. The second formula you provided does not work (and
I changed the E23 to D52). I also put a second parenthesis on the end. That
did not work either.
--
Thank you!


"Sean Timmons" wrote:

Sure thing..

1st cell:

=IF(D23<=4,D23*100,"")

2nd:
=IF(AND(E23="",D23<=8,D23*150,"")

3rd:
=IF(D23=9,D23*200,"")

The 2 cells that don't meet the criteria are left blank.

Please note, I assume 1st cell is entered in E23 in that 2nd formula.

"Lighthouseskrapbooker" wrote:

I'm sure this is an extremely simple question, but I need help with a
formula, hopefully I can explain this in a way that someone can follow: We
give bonuses for the # of loans we process; Each cell has a loan with a
dollar amount, BUT....a cell below that (D23) calculates the total # of JUST
the # of loans (Not the amounts, just the loans, based on how many cells have
entries). I need to create 3 new cells that calculate bonuses on those
loans. 1st cell = if there are 1-4 loans, each loan will get a bonus of
$100, 2nd cell = if there are 5-8 loans then ALL loans will get a bonus of
$150, 3rd cell = if there are 9 or more loans then ALL loans will get a bonus
of $200. Example, if D23 calculates that there are 3 loans, the bonus will
=$300. If D23 calculates that there are 6 loans, the bonus will =$900. If
D23 calculates that there are 9 loans, the bonus will be $1,800. I have
these three cells in one column.
--
Thank you!

Excel formula
 

Oops.. I did miss that.. eek..

=IF(D23<=4,D23*100,"")

2nd:
=IF(AND(D52="",D23<=8),D23*150,"")

3rd:
=IF(D23=9,D23*200,"")

Try that one instead

"Lighthouseskrapbooker" wrote:

Thank you Sean, but this did not work. Cell #1 is located in D51, Cell #2 is
D52, and cell #3 is D52. The second formula you provided does not work (and
I changed the E23 to D52). I also put a second parenthesis on the end. That
did not work either.
--
Thank you!


"Sean Timmons" wrote:

Sure thing..

1st cell:

=IF(D23<=4,D23*100,"")

2nd:
=IF(AND(E23="",D23<=8,D23*150,"")

3rd:
=IF(D23=9,D23*200,"")

The 2 cells that don't meet the criteria are left blank.

Please note, I assume 1st cell is entered in E23 in that 2nd formula.

"Lighthouseskrapbooker" wrote:

I'm sure this is an extremely simple question, but I need help with a
formula, hopefully I can explain this in a way that someone can follow: We
give bonuses for the # of loans we process; Each cell has a loan with a
dollar amount, BUT....a cell below that (D23) calculates the total # of JUST
the # of loans (Not the amounts, just the loans, based on how many cells have
entries). I need to create 3 new cells that calculate bonuses on those
loans. 1st cell = if there are 1-4 loans, each loan will get a bonus of
$100, 2nd cell = if there are 5-8 loans then ALL loans will get a bonus of
$150, 3rd cell = if there are 9 or more loans then ALL loans will get a bonus
of $200. Example, if D23 calculates that there are 3 loans, the bonus will
=$300. If D23 calculates that there are 6 loans, the bonus will =$900. If
D23 calculates that there are 9 loans, the bonus will be $1,800. I have
these three cells in one column.
--
Thank you!

Excel formula
 

I had to change the 2nd cell to read D51, but it worked! Thanks so much!!!
--
Thank you!


"Sean Timmons" wrote:

Oops.. I did miss that.. eek..

=IF(D23<=4,D23*100,"")

2nd:
=IF(AND(D52="",D23<=8),D23*150,"")

3rd:
=IF(D23=9,D23*200,"")

Try that one instead

"Lighthouseskrapbooker" wrote:

Thank you Sean, but this did not work. Cell #1 is located in D51, Cell #2 is
D52, and cell #3 is D52. The second formula you provided does not work (and
I changed the E23 to D52). I also put a second parenthesis on the end. That
did not work either.
--
Thank you!


"Sean Timmons" wrote:

Sure thing..

1st cell:

=IF(D23<=4,D23*100,"")

2nd:
=IF(AND(E23="",D23<=8,D23*150,"")

3rd:
=IF(D23=9,D23*200,"")

The 2 cells that don't meet the criteria are left blank.

Please note, I assume 1st cell is entered in E23 in that 2nd formula.

"Lighthouseskrapbooker" wrote:

I'm sure this is an extremely simple question, but I need help with a
formula, hopefully I can explain this in a way that someone can follow: We
give bonuses for the # of loans we process; Each cell has a loan with a
dollar amount, BUT....a cell below that (D23) calculates the total # of JUST
the # of loans (Not the amounts, just the loans, based on how many cells have
entries). I need to create 3 new cells that calculate bonuses on those
loans. 1st cell = if there are 1-4 loans, each loan will get a bonus of
$100, 2nd cell = if there are 5-8 loans then ALL loans will get a bonus of
$150, 3rd cell = if there are 9 or more loans then ALL loans will get a bonus
of $200. Example, if D23 calculates that there are 3 loans, the bonus will
=$300. If D23 calculates that there are 6 loans, the bonus will =$900. If
D23 calculates that there are 9 loans, the bonus will be $1,800. I have
these three cells in one column.
--
Thank you!

Excel formula
 

I don't seem to read too well! Sorry about that little mess, but happy to help!

"Lighthouseskrapbooker" wrote:

I had to change the 2nd cell to read D51, but it worked! Thanks so much!!!
--
Thank you!


"Sean Timmons" wrote:

Oops.. I did miss that.. eek..

=IF(D23<=4,D23*100,"")

2nd:
=IF(AND(D52="",D23<=8),D23*150,"")

3rd:
=IF(D23=9,D23*200,"")

Try that one instead

"Lighthouseskrapbooker" wrote:

Thank you Sean, but this did not work. Cell #1 is located in D51, Cell #2 is
D52, and cell #3 is D52. The second formula you provided does not work (and
I changed the E23 to D52). I also put a second parenthesis on the end. That
did not work either.
--
Thank you!


"Sean Timmons" wrote:

Sure thing..

1st cell:

=IF(D23<=4,D23*100,"")

2nd:
=IF(AND(E23="",D23<=8,D23*150,"")

3rd:
=IF(D23=9,D23*200,"")

The 2 cells that don't meet the criteria are left blank.

Please note, I assume 1st cell is entered in E23 in that 2nd formula.

"Lighthouseskrapbooker" wrote:

I'm sure this is an extremely simple question, but I need help with a
formula, hopefully I can explain this in a way that someone can follow: We
give bonuses for the # of loans we process; Each cell has a loan with a
dollar amount, BUT....a cell below that (D23) calculates the total # of JUST
the # of loans (Not the amounts, just the loans, based on how many cells have
entries). I need to create 3 new cells that calculate bonuses on those
loans. 1st cell = if there are 1-4 loans, each loan will get a bonus of
$100, 2nd cell = if there are 5-8 loans then ALL loans will get a bonus of
$150, 3rd cell = if there are 9 or more loans then ALL loans will get a bonus
of $200. Example, if D23 calculates that there are 3 loans, the bonus will
=$300. If D23 calculates that there are 6 loans, the bonus will =$900. If
D23 calculates that there are 9 loans, the bonus will be $1,800. I have
these three cells in one column.
--
Thank you!