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