View original (French)

Integer number excel

Solved
horus63 -  
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

4 answers

  1.
    Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   6 453
     
    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?
    17
    1. 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!
      0