Noble Excel Functions

[Jtucker10278]

I was looking for the formula to only return whole numbers from and equation. TRUNC seemed to fit my needs but I couldn't find any examples of it being used in a formula only as a standalone for converting an existing number.

granted it took me only 1 try to figure it out

=Trunc(A1*B1)

but at that point I was already halfway down the rabbit hole., and now I am curious if there are any stand alone functions in Excel that won't interact with any other Functions.

 

[Cubist]

What does "stand-alone" mean?
I believe all functions interact with each other as long as the inputs are valid.

 

[jolivanes]

=INT(A1*B1)

3 less letters to type!!!!!

 

[Alex Blakenburg]

jolivanes raises a good point though. Do you have any negative numbers and what do you want to happen when converting to a whole number with negative numbers.

Book3
	A	B	C	D
4	Initial Value	=TRUNC(A5)	=INT(A5)	=ROUNDDOWN(A5,0)
5	-4.3	-4	-5	-4
6	-4.6	-4	-5	-4
7	4.3	4	4	4
8	4.6	4	4	4
9	5.3	5	5	5
10	5.6	5	5	5
Sheet1

Cell Formulas
Range	Formula
B4:D4	B4	=FORMULATEXT(B5)
B5:B10	B5	=TRUNC(A5)
C5:C10	C5	=INT(A5)
D5:D10	D5	=ROUNDDOWN(A5,0)
A7:A8	A7	=-A5

 

[Scott Huish]

INT is going to round the number while TRUNC won't.
If you want rounding and say a number like -4.6 should round up to -4 and 4.6 should round up to 5
then I would do this:
=-INT(-A1*B1)

 

[Eric W]

Excel has a lot of functions to convert a number to an integer. INT, TRUNC, FLOOR.MATH, CEILING.MATH, ROUND, MROUND, ROUNDUP, ROUNDDOWN. Even these don't encompass the whole world of rounding. There's Argentina rounding, Swiss rounding, or Banker's rounding. It's probably best if you can give some examples of numbers, and what you want the results to be, and why.