Returning an Integer Value.

[Confused!]

If you want to find the sum of any two numbers, with, say, up to six decimal places, which return an integer as the result, what is the Excel Function that finds that for you?

i.e 24.166382 + -5.332763255 = 18.833618, so FALSE
and
2.157929 + 17.84207054 = 20, so TRUE

 

[Weaver]

deleted

 

[alansidman]

Try this:

Excel Workbook
	O	P
1	24.166382
2	-5.332763255
3	18.83361875	18
4
5	2.157959
6	17.84207054
7	20.00002954	20
Sheet1

 

[Weaver]

Possibly

=MOD(ROUND(A2,6)+ROUND(B2,6),1)=0

 

[snipescc]

It's awkward, and they may be a better way, but I have a suggestion. Have a column that adds a very small amount, like .000000001, and has 8 decimal places. Then have a conditional formating column that searches for ".00000001" within the number. An integer would have just the small amount to the right of the decimal point, but a non-integer would have other numbers there as well.

Like I said, squward, but if there isn't a function for it, that may get you what you need.

 

[T. Valko]

If you want to find the sum of any two numbers, with, say, up to six decimal places, which return an integer as the result, what is the Excel Function that finds that for you?

i.e 24.166382 + -5.332763255 = 18.833618, so FALSE
and
2.157929 + 17.84207054 = 20, so TRUE

Not sure what you're wanting to do...

Maybe this...

=ROUND(2.157929+17.84207054,0)=20

ROUND(...,0) will round to the nearest integer.

INT(...) will return just the integer with no rounding

INT(2.157929) = 2
INT(17.84207054) = 17

 

[JamesW]

=if(round(a1+b1,6)=int(round(a1+b1,6)),true,false)