to show interger only

[chubbychub]

I have this formula but I only want to show intergetrs only, so if its 2.75, I want to show 2
for example:
2.7 to show 2
1.3 to show 1
5.5 to show 5

here is the formula :

 =IFERROR(INDEX(P$2:P$39, MATCH($A3&"-"&$B3&"-"&$C3, INDEX($L$2:$L$1000&"-"&$M$2:$M$1000&"-"&$N$2:$N$1000, 0), 0))/D3, 0)

please help, thanks

[alansidman]

Assume your data is in column A. Then =Int(A1)

[chubbychub]

how do I put it in that formula? or whats the syntax?

[Tony Valko]

how do I put it in that formula? or whats the syntax?

Like this...

=IFERROR(INT(INDEX(P$2:P$39, MATCH($A3&"-"&$B3&"-"&$C3,INDEX($L$2:$L$1000&"-"&$M$2:$M$1000&"-"&$N$2:$N$1000,0),0))/D3),0)

[chubbychub]

whats the difference if I put it this way? or will it work this way?

=(INT(IFERROR(INDEX(P$2:P$39, MATCH($A3&"-"&$B3&"-"&$C3, INDEX($L$2:$L$1000&"-"&$M$2:$M$1000&"-"&$N$2:$N$1000, 0), 0))/D3, 0))

[Tony Valko]

whats the difference if I put it this way?

It should work either way.

[chubbychub]

thank you all alansidman and tony!

[Tony Valko]

You're welcome!