Excel VBA IF, Else IF, Else

This video illustrates how to use the IF Function in Excel VBA with multiple conditions. In this example we have a dataset of Monthly Sales for multiple Employees. Each Employee gets a 5.00% Bonus if their monthly Sales are greater than or equal to $10,000. If the Sales are less than $10,000 but greater than or equal to $7,500 the Sales Rep gets a 3.00% Sales Bonus. Any Sales Rep below $7,500 does not get a bonus. The objective is to write Code in VBA that will apply the correct Sales Bonus % & Amount to each Sales Employee row in our dataset based on their respective Sales Amount.
Learn More about Excel VBA & Macros with this Book on Amazon:
amzn.to/3xnqT6R
Get a Microsoft Office 365 Personal Subscription with this Amazon link:
amzn.to/3aV9GtL
DISCLAIMER: As an Amazon Affiliate I get a commission for every purchase via these links.
To get a copy of the workbook used in this video click the link below:
theexcelcave.w...