Thread: no decimals
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
BorisS BorisS is offline
external usenet poster
 
Posts: 191
Default no decimals

I have two cells that add up to a third. I need to validate or do something,
which limits the first two cells' inputs, to where the sum of the two does
not equal a decimal. The order in which the two cells will be input is not
certain, and so the "validation" must be on both input cells.

So what I need is what to apply, and to what cells. I'd like to avoid VB if
possible, so am hoping there's a way to do this with validation.

Thx.
--
Boris