Formula to show number of Units and remainder

[Jerroldac]

I am looking for a formula
if I have 110 units and I need to find out how many Y units (Y=32 units) there are, and show a remainder.
110 Units / Y = 3Y14
The answer is 3Y14, but how would I put it into an Excel formula?


Thank you
Jerrold

[modytrane]

You'll be asked to change the title of your post.
Being that you're new here, I'll help you.

If 110 is in A1 and 32 in B1 then this formula will work:

[Pete_UK]

A slightly shorter approach:

=INT(A1/B1)&"Y"&MOD(A1,B1)

Hope this helps.

Pete