Microsoft Office Forums IF formula - multiple conditions

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-10-2019, 06:50 PM
rameen rameen is offline IF formula - multiple conditions Windows XP IF formula - multiple conditions Office 2016
Novice
IF formula - multiple conditions
 
Join Date: Feb 2019
Posts: 1
rameen is on a distinguished road
Default IF formula - multiple conditions


Hi,

I am trying to calculate the following using an if formula:

Sales GP% Bonus
50% 90% 2%
60% 95% 3%

How can I use the above data to calculate the Bonus amount in $, when (condition 1) sales are higher than 50% but lower than 60% and (condition 2) GP % is higher than 90% but lower than 95%. Bonus percentage needs to be picked according to these conditions so from the above data, there could be 4 possible combinations for the formula to look at.

Thanks.

Rameen.
Reply With Quote
  #2  
Old 02-11-2019, 12:37 AM
ArviLaanemets ArviLaanemets is offline IF formula - multiple conditions Windows 8 IF formula - multiple conditions Office 2016
Expert
 
Join Date: May 2017
Posts: 464
ArviLaanemets will become famous soon enoughArviLaanemets will become famous soon enough
Default

Into your table with data, add a column (may be hidden) , where depending on sales and GP % the bonus group number (values 1, 2, 3 or 4) for every row is calculated.
The bonus will be calculated as
Code:
=CHOOSE(BonusGroupNumber, Bonus1, Bonus2, Bonus3, Bonus4)
where Bonus# are numeric values for different bonuses like 0.01, 0.03, etc.
Reply With Quote
Reply

Tags
if formula

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with formula with more conditions allex011 Excel 1 10-29-2018 03:22 AM
Formula to make sum based on multiple conditions, HELP! ilsel Excel 3 11-15-2017 02:03 AM
Excel Formula for Multiple Conditions & Results nowco Excel 4 03-16-2016 11:24 AM
IF formula - multiple conditions Multiple If Conditions z941714 Excel 8 08-09-2015 04:12 PM
6 conditions formula paconovellino Excel 2 03-05-2012 06:45 AM


All times are GMT -7. The time now is 11:36 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft