Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Formula for Cell Calculations

G44 I44 J44 K44
L44
Revenue Total Revenue Quota At Risk $ % of Quota
Commissions
$1,937.00 $675.00 $1,100.00 286.96% $1,925.00

I need to calculate the data for Commissions:
Formula to check
If "K44" is less than, or equal to 100%, then "L44" is equal to "J44".

If "K44 is greater than 100%, but less than 175%, then "L44" is equal to
"J44" times "K44".

If "K44" is greater than 175%, then "L44" will always a MAXIMUM of "J44"
times 175%

Short explanation:

Salesperson gets the At Risk amount for anything 100% of quota, or less.
They can make extra commissions, but NOT TO EXCEED 175% of the AT Risk Amount.

The Quota and At Risk amounts change monthly.



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
Multiple Calculations in a Formula kjguillermo Excel Discussion (Misc queries) 2 October 11th 06 01:29 AM
I need a formula to do some calculations with time. littledeb31 Excel Worksheet Functions 2 September 17th 06 07:56 AM
Calculations Using the =IF formula ChesireCat Excel Worksheet Functions 3 March 3rd 05 04:13 AM
Countif Formula with 2 calculations Belinda Excel Discussion (Misc queries) 7 November 26th 04 03:55 PM
Can you enter a formula in a cell that auto-inputs calculations a. proactive Excel Worksheet Functions 4 November 9th 04 06:00 AM


All times are GMT +1. The time now is 09:43 PM.

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

About Us

"It's about Microsoft Excel"