Thread: Want a quotient using a constant to show up in column c each time a number is added to column b
View Single Post
 
Old 12-08-2014, 05:26 PM
fibbermcghee fibbermcghee is offline Windows 7 64bit Office 2007
Novice
  
Join Date: Dec 2014
Posts: 2
fibbermcghee is on a distinguished road
Default Want a quotient using a constant to show up in column c each time a number is added to column b
Hi all,

I'm using Excel 2007 in Win 7.

I'm trying to set up two columns within a spread sheet so that every time a new number is entered into Column B, (for instance) the quotient arrived at by dividing that number by a constant appears in Column C on the same row. New numbers will be added to Column B a few times an hour, often enough that I don't want to enter a formula for each entry. Not real experienced with Excel, but used Basic about 20 years ago, if that helps.

and sorry if this has been answered already, I couldn't find it.
Last edited by fibbermcghee; 12-08-2014 at 05:27 PM. Reason: spelling
Reply With Quote