Losing the .## and calculating whole numbers

[vartmp]

Here is my dilemma.

A=13
B=4
C=A/B
= 3.25

Now, If I change the format of C to be 0 decimal points, I get 3. - Brilliant!
But, when I calculate using C, it still keeps the total 3.25.

I just want to calculate using 3.

Ultimately, I want to calculate the remainder as a whole number too.

So, B goes into A 3 times with a remainder of 1.

Any clues?

Thanks in advance.

[JohnTopley]

In C1

=INT(A1/B1)

in D1

=MOD(A1,B1)

[Jonmo1]

I might suggest ROUND instead of INT.

If the result of A/B is say 3.6, then formatting it to 0 decimals would show 4, but INT(A/B) would be 3

=ROUND(A1/B1,0)

[JohnTopley]

Not what I understood the OP wants

A1=14
B1= 3

Round (A1/B1,0)= 5

Ultimately, I want to calculate the remainder as a whole number too.

So, B goes into A 3 times with a remainder of 1. (with value of 13)

Having the ROUND result of 5 but MOD of 2 doesn't not make sense (to me!).

The ambiguity of English!

[Jonmo1]

Good point,
If 'ultimately' we're after the remainder, then we don't even need the intermidiate A1/B1 calcuation
MOD is all that is needed.


My post was based on only the first half of the post, making the result of A/B match the result of the rounding done by cell formatting.

[JohnTopley]

I just want to calculate using 3.

Ultimately, I want to calculate the remainder as a whole number too

Both required I think (?)