| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
| Build excel formula using field values as text in the formula | Excel Worksheet Functions | |||
| Excel Formula Doesn't Execute (Shows formula-not the calcuation) | Excel Discussion (Misc queries) | |||
| Excel 2002 formula displayed not value formula option not checked | Excel Worksheet Functions | |||
| i edit a formula (excel) then it displays formula not answer | Excel Discussion (Misc queries) | |||
Hybrid Mode
