Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 2nd 17, 10:48 PM
Junior Member
 
First recorded activity by ExcelBanter: Feb 2017
Posts: 2
Exclamation Excel Help! Multiplication Formula With A Max And Min Value

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!!!!

  #2   Report Post  
Old February 2nd 17, 11:21 PM
Junior Member
 
First recorded activity by ExcelBanter: Feb 2017
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?
  #3   Report Post  
Old February 3rd 17, 01:01 AM
Junior Member
 
First recorded activity by ExcelBanter: Feb 2017
Posts: 2
Default

Quote:
Originally Posted by billyk81 View Post
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?
So what I'm trying to do is create a maximum commission amount and minimum commission amount within my formula.

At my job, we have a minimum commission and maximum commission amount on the loans we close.
  #4   Report Post  
Old February 3rd 17, 04:17 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2015
Posts: 728
Default Excel Help! Multiplication Formula With A Max And Min Value

billyk81;1628244 Wrote:
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?


So what I'm trying to do is create a maximum commission amount and
minimum commission amount within my formula.

At my job, we have a minimum commission and maximum commission amount
on the loans we close.


You can't have 2 results in the same cell! Create a 'Min" column and a
"Max" column and have both calc their respective results...

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion
  #5   Report Post  
Old February 3rd 17, 04:34 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2016
Posts: 5
Default Excel Help! Multiplication Formula With A Max And Min Value

Maybe you are looking for the following
=MAX(MAX(A13,A9),MIN(A11,A9))


  #6   Report Post  
Old February 3rd 17, 04:34 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2016
Posts: 5
Default Excel Help! Multiplication Formula With A Max And Min Value

Maybe you are looking for the following
=MAX(MAX(A13,A9),MIN(A11,A9))


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with multiplication formula Josh W Excel Worksheet Functions 3 June 18th 09 01:20 PM
How do I add the sum of a multiplication formula to another cell Creede Tibbs Excel Programming 1 March 10th 08 06:23 AM
Addition & multiplication formula Vi Excel Discussion (Misc queries) 7 January 18th 08 05:32 PM
Simple Multiplication Formula MP[_3_] Excel Programming 8 December 20th 07 04:23 PM
Vlookup and Multiplication formula Gladys Excel Discussion (Misc queries) 1 October 9th 06 06:37 PM


All times are GMT +1. The time now is 08:13 PM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017