IF a whole number then...

[wwbwb]

I'm trying to set up a formula so that if the number in a1 is a whole number then the formula will return "Yes" otherwise "No". This is what I have so far, just wondering if there is a simpler way?

=if(round(a1,0)=a1,"Yes","No")

 

[Aladin Akyurek]

=(A1-TRUNC(A1)=0)+0

Custom format the formula cell as:

[=0]"No";[=1]"Yes"

if needed.

Otherwise:

1 --> Yes
0 --> No

 

[Brian from Maui]

Try,

=IF(MOD(A1,1)=0,"YES","NO")

 

[Anthony47]

Hi wwbwb,
your formula is ok, or you could use

=IF(MOD(A1,1),"No","Yes")

or

=IF(INT(A1)=A1,"Yes","No"

But, as you see, they have all the same (limited) complexity.
Bye,

 

[wwbwb]

Thanks all. They all work for what I need.