Microsoft Office Forums IF formula - multiple conditions

Go Back   Microsoft Office Forums > >

Thread Tools Display Modes
Old 02-10-2019, 06:50 PM
rameen rameen is offline IF formula - multiple conditions Windows XP IF formula - multiple conditions Office 2016
IF formula - multiple conditions
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 IF formula - multiple conditions Windows 8 IF formula - multiple conditions Office 2016
Join Date: May 2017
Posts: 467
ArviLaanemets will become famous soon enoughArviLaanemets 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
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 02:04 PM.

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. is not affiliated with Microsoft