Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

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


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.


Reply With Quote
Old 02-11-2019, 12:37 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Join Date: May 2017
Posts: 424
ArviLaanemets will become famous soon enough

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
=CHOOSE(BonusGroupNumber, Bonus1, Bonus2, Bonus3, Bonus4)
where Bonus# are numeric values for different bonuses like 0.01, 0.03, etc.
Reply With Quote

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
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 03:43 PM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc. is not affiliated with Microsoft