Decimal Places

[Simon Argent]

Hi,

I am currently having a problem with decimal places.
Basically I don't want any whatsoever.

In a cell, I am doing division between 2 figures to find
out how many items I can purchase with an amount of money.

So, the formula is
AmountOfMoney/CostOfItem

If the ansewr was for example 63.97 then the results cell
would show 64 (I have it set so that 0 decimals are shown)

There are then other calculations throughout the
spreadsheet that use this result. However, since I can
only afford 63 WHOLE items, I don't want the 0.97 to be
included as part of the equation since this throws out all
of my figures.

Is there any possible way that I can force excel to round
a figure down or just use whole numbers?

Many thanks in advance,
Simon

 

[Tom Ogilvy]

=rounddown(AmountOfMoney/CostOfItem,0)

or

=Trunc(AmountOfMoney/CostOfItem)

 

[Dan E]

Simon,

Three options,

Quotient gives the integer portion of a division
=QUOTIENT(A1,B1)
The remainder can be returned using
=MOD(A1,B1)
In the above case A1 is the numerator, B1 is the
denominator

Int also returns the integer portion of a number
=INT(A1/B1)

Rounddown rounds down
=ROUNDDOWN(A1/B1,0)

Dan E

 

[Simon Argent]

Many thanks to both of you. I have managed to get the
RoundDown function working and now all my figures are
perfect