![]() |
Numeric input in E to divide by 2 automatically in H
I input dollar amounts in column E, and I want them to automatically divide
by 2 in column H. |
Numeric input in E to divide by 2 automatically in H
=E2/2
-- Regards, Peo Sjoblom "Dale G" <Dale wrote in message ... I input dollar amounts in column E, and I want them to automatically divide by 2 in column H. |
Numeric input in E to divide by 2 automatically in H
Dale G,
Enter this formula in H2 and copy/fill down as needed: =E2/2 HTH, Conan "Dale G" <Dale wrote in message ... I input dollar amounts in column E, and I want them to automatically divide by 2 in column H. |
Numeric input in E to divide by 2 automatically in H
Thank you, I figured it out. I had to set my fomula calculations to auto.
"Peo Sjoblom" wrote: =E2/2 -- Regards, Peo Sjoblom "Dale G" <Dale wrote in message ... I input dollar amounts in column E, and I want them to automatically divide by 2 in column H. |
All times are GMT +1. The time now is 04:36 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com