HOW DO I SELECT ROUND NUMBERS ONLY IN EXCEL SPREADSHEET

J

Jez

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
 
R

Roger Govier

Hi

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

Regards

Roger Govier
 
J

Jez

Hi, Thanks very much for that - fantastic

Roger Govier said:
Hi

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

Regards

Roger Govier
Click to expand...
 
Top