Thread: Cell can only equal Whole Number
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph
 
Posts: n/a
Default Cell can only equal Whole Number
"TriFiV" wrote in message
...
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


Reply With QuoteReply With Quote