For the formula try:

=If(Mod(A1/B1,1)0, "Error",A1/B1)

Or you can use Mod in a conditional format and change the cell format if in
error.
--
rand451
"mkirkley" wrote in message
...
I am working with one of our engineers that wants to have a cell with a
formula show only whole numbers. He does not want rounding, but to be
able
to code a statement that will error out if the result is a deciaml or
fraction. I looked at the Data - validation properties, but it only works
with an entered number not a formula. Is there a simple way to do it
without
having to write a program in vb?