quick excel help needed, and a treat very soon!

[wilhil]

Hi

I am about to release a file that should help alot of you with your game and upgrades, to myknowledge there is not one like it here.

there is one thing I can not figure out, I have not been using excel in some time, anyway, how do I get rid of the decimal point and following figures in a cell but not make it round up?

I understand how to do it normally, but 1.9 will become 2, and I really need even 1.99999 to become 1, as it must be a whole number only.

can anyone help me here?

Thanks

[Ed Kolis]

TRUNC chops off the decimals.
INT rounds down.
There's a subtle difference, in that -2.5 will TRUNC to -2, but INT to -3.

[wilhil]

Thanks!

when you say about negative numbers, is that just for negatives, so 2.5 ints and truncs to 2, whilst 2.6 will int to 3 whilst trunc is 2?

if I get what you are saying, trunc is what I am looking for! thanks (int is not needed now, but useful to know! I have not really been going through the functions! but this is good!)

[Ed Kolis]

Not quite... 2.6 would also int to 2, because int rounds *down* no matter what. But that doesn't seem to be what you need, so that doesn't matter
What is this spreadsheet you're working on anyway? You said it had to do with the "game and upgrades" - do you mean modding families of components and such? If so I'd really love to see it... somehow I can't make myself use an *old* version of the templatizer, since I lost the latest version!

[Slick]

if you want to round in the traditional sense, add 0.5 then trunc.

[wilhil]

here is what I was making

http://www.shrapnelcommunity.com/thr...b=5&o=&fpart=1

I hope you enjoy, also, what is templatizer? is it something SE or general excel related?

and I dont get int then! is the only diffrence between int and trunc when you have negative numbers?

I havent done any good maths in years! and thank you trunc worked!