View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Diane Diane is offline
external usenet poster
 
Posts: 96
Default If Statement help

I have a run of cells that have values with 8 decimal places. This run of
numbers must end up totaling 1.00000000. I need an "if" that would look at
the sum and IF the total does not enter 1.00000000, if will go up and modilfy
the values so that they do equal 1.00000000.
--
Thanks. God bless