View Single Post
  #2   Report Post  
billyk81 billyk81 is offline
Junior Member
 
Posts: 3
Default

Quote:
Originally Posted by NGOULD View Post
Good afternoon everyone! :-)

I have been stuck trying to create a formula for my spreadsheet and was praying that someone could help me. I have spent hours on google searches trying to come up with this formula and I've had no luck.

Cell A11 = Maximum Commission

Cell A13 = Minimum Commission

Cell A9 = Commission Amount (%)

Cell I2 = Loan Amount


I am a lender and I am trying to create a formula that calculates the amount of commission I'll receive on a loan. I have a minimum and maximum commission that I receive as well.


I have tried the IF functions for maximum and minimum but I am having difficulty combining those functions into the same field.


I wanted a function that stated;

Loan amount * Commission Amount = Commission with a Max commission amount and minimum commission amount.

Can someone please help me out with this!?

THANK YOU SO MUCH!!!!

I think you need to give us more info... The loan amount * Commission % will always give you the same amount. I am not sure where the min and max come into play?