View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
derekc[_5_] derekc[_5_] is offline
external usenet poster
 
Posts: 1
Default insert amount into first emtpy cell

i have already have something written out to subtract cells fro
eachother in a row until it hits a neg. number. then it stops on tha
last pos number. i want to have the number left over from th
subtractions to be added at the end of the row in the first emtp
cell.
so if a1 - b1 - c2 = 23 i want 23 in the first empty cell in that row
and so it will do it for each row. i have the subtraction part down
just need something to tell it to add whats left over into the firs
emtpy cell on the row. if any info needed just reply. thank

--
Message posted from http://www.ExcelForum.com