#### Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

# Can Smartsheet to perform a Mod Function?

Options
edited 12/09/19

I am a network engineer and I am importing an excel spreadsheet into smartsheet.

My spreadsheet is an address calculator for quiclky identifying IP addressing for my organization. My spread sheet has the use of the "MOD" function and is contigent upon using this function.

I am aware that the "MOD" function provides the remainder after division. Is there a way to accomplish this in Smartsheet?

Excel Example:    =MOD(F3,64)*4

where F3 = 296

My spreadsheet returns the following result.

=MOD(F3,64)*4    = 160

My work around in smartsheet is such:

=(F3/64)*4

where F3 = 296

My result in Smart sheet is:

=(F3/64)*4   = 18.5

As seen in my example my work around is not providing the result desired.

Respectfully,

Tags:

• ✭✭✭✭✭✭
Options

Matt,

Try this:

=(F3 - (64 * INT(F3/64))) * 4

The Modulus MOD(A,N) is:

=A - (N * INT(A/N))

and then in your example you multiply by 4

Hope this helps.

Craig

• Options

You sir, get it! Thank you! That works

This discussion has been closed.