Re: quick excel help needed, and a treat very soon
The point of INT is to be used as a FLOOR() function, which returns the next-lowest integer value for real number input (if the input is an integer, the function returns the input). TRUNC on the other hand, just takes any real number, and removes any decimal digits that it may have.
So yes, for positive real numbers, there is no difference between the results of INT and TRUNC. And for negative real numbers, there is no difference between CIEL and TRUNC. But there are uses for all three.
__________________
GEEK CODE V.3.12: GCS/E d-- s: a-- C++ US+ P+ L++ E--- W+++ N+ !o? K- w-- !O M++ V? PS+ PE Y+ PGP t- 5++ X R !tv-- b+++ DI++ D+ G+ e+++ h !r*-- y?
SE4 CODE: A-- Se+++* GdY $?/++ Fr! C++* Css Sf Ai Au- M+ MpN S Ss- RV Pw- Fq-- Nd Rp+ G- Mm++ Bb@ Tcp- L+
|