L
Lighthouseskrapbooker
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.
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.