HOW DO I SELECT ROUND NUMBERS ONLY IN EXCEL SPREADSHEET

I want to write a formula where if a cell contains a whole number a certain
value will be returned (true) but if its not a whole number (false) another
value will be returned. Thanks for any help

Hi

One way
=IF(INT(A1)=A1,1,2)
Replace 1 and 2 with your values or cell references.

Regards

Roger Govier


Jez wrote:
> I want to write a formula where if a cell contains a whole number a certain
> value will be returned (true) but if its not a whole number (false) another
> value will be returned. Thanks for any help

Hi, Thanks very much for that - fantastic

"Roger Govier" wrote:

> Hi
>
> One way
> =IF(INT(A1)=A1,1,2)
> Replace 1 and 2 with your values or cell references.
>
> Regards
>
> Roger Govier
>
>
> Jez wrote:
> > I want to write a formula where if a cell contains a whole number a certain
> > value will be returned (true) but if its not a whole number (false) another
> > value will be returned. Thanks for any help
>