Can Smartsheet to perform a Mod Function?

Matt Laguna

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, 

 

 

J. Craig Williams

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

Matt Laguna

You sir, get it! Thank you! That works