"TriFiV" <TriFiV@discussions.microsoft.com> wrote in message
news:2FAED89E-35F0-4EF6-8F47-C69F2AF77B2C@microsoft.com...
>I need set up a formula so that if the answer is not a whole number, an
>error
> message will show. Thank you.

=IF(MOD(your formula,1)=0,your formula, "Error")
--
David Biddulph