I input dollar amounts in column E, and I want them to automatically divide by 2 in column H.
D Dale G Dec 13, 2007 #1 I input dollar amounts in column E, and I want them to automatically divide by 2 in column H.
C Conan Kelly Dec 13, 2007 #3 Dale G, Enter this formula in H2 and copy/fill down as needed: =E2/2 HTH, Conan