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?
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,
Comments
-
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 -
You sir, get it! Thank you! That works
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives