To repeat a fixed value every 3 months, you can use a formula based on the DATEDIF and MOD functions. In the example shown, the formula in C4, copied down, is:
=IF(B4>=start,(MOD(DATEDIF(start,B4,"m")+n,n...

To highlight numbers that are integers, you can use a simple formula based on the MOD function. In the example shown, conditional formatting has been applied to the range B4:G11 using this formula:
=MOD(B4,1)=0
Note...

To convert a measurement in inches to inches and feet (i.e. 53 to 4' 5") you can use a formula based on the INT and MOD functions. In the example shown, the formula in D5 is:
=INT(B5/12)&"' "&MOD(B5,...

To generate a fixed value every N columns (for example, a fixed expense every 3 months, a fixed payment every 6 months, etc.) you can use a formula based on the MOD function.
In the example shown, generate a value of...

To sum every nth column, you can use a formula based on the SUMPRODUCT, MOD, and COLUMN functions.
In the example shown, the formula in L5 is:
=SUMPRODUCT(--(MOD(COLUMN(B5:J5)-COLUMN(B5)+1,K5)=0),B5:J5)
How this...

To calculate work hours, taking into account break time that needs to be subtracted, you can use a formula based on the MOD function. MOD is used to handle start and end times that cross midnight. In the example shown,...

To add a given number of minutes to a time, you can add minutes divided by 1440, or use the TIME function.
In the example shown, the formula in D5 is:
=B5+(C5/1440)
Note: make sure results are formatted as time....

To count cells that contain only odd numbers, you can use a formula based on the SUMPRODUCT function together with the MOD function.
In the example, the formula in cell E6 is:
=SUMPRODUCT(--(MOD(rng,2)=1))
This...

Excel handles dates and time using a scheme in which dates are serial numbers and times are fractional values. For example, June 1, 2000 12:00 PM is represented in Excel as the number 36678.5, where 36678 is the date...

To add a given number of hours to a time, you can add hours divided by 24, or use the TIME function.
In the example shown, the formula in D5 is:
=B5+(C5/24)
Note: make sure results are formatted as time.
How this...

To get the max of every nth column, you can use an array formula based on the MAX, MOD, and COLUMN functions. In the example shown, the formula in M5 is:
=MAX(IF(MOD(COLUMN(B5:K5)-COLUMN(B5)+1,L5)=0,B5:K5))
Note:...

To highlight numbers that are multiples of a another number with conditional formatting, you can use a simple formula based on the MOD function.
In the example shown, the formula used to highlight multiples of 9 is...

To add an ordinal suffix to a number (i.e. 1st, 2nd, 3rd, etc.) you can use a formula based on the CHOOSE function to assign the suffix.
In the example shown, the formula in C5 is:
=CHOOSE(B5,"st","nd...

To calculate the number of hours between two times, you can use a formula that simply subtracts the start time from the end time. This is useful to calculate working time, calculate elapsed time, etc. However, when...

If you want to highlight every other row in a table (sometimes called zebra striping) with conditional formatting you can do so with a simple formula that uses either the ISEVEN or ISODD function. For example, if you...