## Excel Function of the Week - MOD

The MOD function is very useful in certain circumstances.

The function returns the integer remainder after a number has been divided by a divisor. For example if you divide 10 by 3, it goes in 3 times with one remaining. ## Developing in Excel 2007

I much prefer working in Excel 2007 to Excel 2003. Despite the issues with backward compatibility, there are a lot of advantages and benefits to using the new version.

Some little things that have been changed are

The previous limit on nested brackets in formulas from 7 has been increased to 64. I used this today

The number of columns and rows has increased. I used this today.

I had to develop a file for a client that involved a complex work roster arrangement to calculate days off in repeating 2, 3 or 4 week cycles for the next 20 years.

Here is the nested formula that got me the logic for a roster.

=IF(\$X5>=AJ\$4,\$X\$4,IF(\$Y5>=AJ\$4,\$Y\$4,IF(\$Z5>=AJ\$4,\$Z\$4,IF(\$AA5>=AJ\$4,\$AA\$4,IF(\$AB5>=AJ\$4,\$AB\$4, IF(\$AC5>=AJ\$4,\$AC\$4,IF(\$AD5>=AJ\$4,\$AD\$4,IF(\$AE5>=AJ\$4,\$AE\$4,IF(\$AF5>=AJ\$4,\$AF\$4,\$AG\$4)))))))))

I then used one formula to generate over 600,000 cells and create a map that looks like this.