|
|
|
Complex IF Function
Example
Use the IF
function to solve a complex problem across multiple columns
Q: |
We are a chamber of commerce with a complicated
dues structure. Can you help me figure out how to calculate dues
based on the total number of employees using the following table?
|
|
First 5 employees |
$165 Total |
Next 5 |
add $5 per employee |
Next 15 |
add $4 per |
Next 20 |
add $3 per |
Over 50 |
add $2 per |
|
|
|
A: |
Eric what you want to do is not necessarily
difficult if you can break it up into multiple steps using the IF
function and some basic math.
|
|

|
|
Here is a FREE video
tutorial that shows you how to set up this spreadsheet step-by-step:
If you need a more basic understanding of how the
IF function works,
check out this tutorial. |

By Richard Rost
Click here to sign up for more FREE tips
|
Check out these other pages that may be of interest to you: |
|