I just received another excellent Excel question that I posted a FREE video answer to. This person wanted to know how to take a very complex dues structure and create a spreadsheet to figure out membership dues based on the number of employees per member company. I solve the problem with a set of IF functions and some math. See for yourself:

/tips/excel/complex-if-example

Enjoy.