Integer number excel
Solved
horus63
-
Patrice33740 Posted messages 8400 Registration date Status Member Last intervention -
Patrice33740 Posted messages 8400 Registration date Status Member Last intervention -
Hello,
I am looking for a formula that allows me to automatically "detect" integer (or decimal) numbers in a list, and if this condition is true --> put a * in the adjacent column as in the example below:
Column A Column B
1 *
1.2
1.3
2 *
3 *
3.2
Thank you in advance for your response
Configuration: Windows XP / Firefox 3.6.15
I am looking for a formula that allows me to automatically "detect" integer (or decimal) numbers in a list, and if this condition is true --> put a * in the adjacent column as in the example below:
Column A Column B
1 *
1.2
1.3
2 *
3 *
3.2
Thank you in advance for your response
Configuration: Windows XP / Firefox 3.6.15
4 answers
Good evening
one solution among others:
=IF(A1-INT(A1)=0,"*","")
which will detect whole numbers
or even:
=IF(MOD(A1,INT(A1))=0,"*","")
best regards
Let’s ask ourselves if we are not the only ones who understand what we are explaining?
one solution among others:
=IF(A1-INT(A1)=0,"*","")
which will detect whole numbers
or even:
=IF(MOD(A1,INT(A1))=0,"*","")
best regards
Let’s ask ourselves if we are not the only ones who understand what we are explaining?
horus63
It works, thank you, and if I have a value "batarde" in my list, for example 1D, it doesn't work anymore!! Is there a way to fix that!
