Hello,

Running Excel (Office 2007) on WinXP.

My spreadsheet is used for tracking sales of Girl Scout cookies. Need to
determine how many cases and/or boxes of cookies are needed. 12 boxes per
case.

Columns B-I are for each type of cookie.
Rows 4-33 are 1 scout per row.
Row 34 are totals for each type of cookie.
Row 35 has how many cases are needed for each type of cookie.
Row 36 should show how many individual boxes are needed.

Problem:
Row 36 needs to say how many individual boxes are needed.
So, this needs to be the remainder left over after determining the number of
cases.

If I use actual numbers "=MOD(37,3)", result is 1, and is correct.
The formula I'm using is: =MOD (B34,B35)
This always returns a green 0 (zero)
Why? What am I doing wrong?

Thanks,

Rich