If Integer function

[goodtimes]

Hello. New user here looking for some assistance please.

I'm trying to write a statement something like:

B1 = data

B2=IF(B1/8=0,"",IF(B1/8=INTEGER,B1/8 & "8/8",B1/8+1))

This is meant to identify which relay on a relay board is associated with the given data. For example if data=3, B2 = 1 3/8 meaning the 3rd relay on board 1. If data = 77, B2 = 10 5/8 meaning the 5th relay on board 10. I could do without the 10, but the 5th relay on that board is important to me.

In summary, I think my trouble is identifying when the product of B1/8 is an integer. I may also be having trouble combining value and text.

Well, there it is. I may very well be going about it all wrong.
Any assistance would be greatly appreciated.

[rwgrietveld]

I think the MOD (for the remainder) is your solution
=ROUNDUP(B1/8,0)&" "&MOD(B1,8)&"/8"

[protonLeah]

The MOD() function will tell you if the remainder of the division is zero:

Please Login or Register  to view this content.

[goodtimes]

Thank you so much!! That worked out great. I would never have thought of that.

I really appreciate your help.