ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Numeric input in E to divide by 2 automatically in H (https://www.excelbanter.com/excel-discussion-misc-queries/169632-numeric-input-e-divide-2-automatically-h.html)

Dale G

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.

Peo Sjoblom

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.




Conan Kelly

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.




Dale G[_2_]

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