Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-08-2014, 05:26 PM
fibbermcghee fibbermcghee is offline Want a quotient using a constant to show up in column c each time a number is added to column b Windows 7 64bit Want a quotient using a constant to show up in column c each time a number is added to column b Office 2007
Novice
Want a quotient using a constant to show up in column c each time a number is added to column b
 
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
  #2  
Old 12-09-2014, 02:00 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Want a quotient using a constant to show up in column c each time a number is added to column b Windows 7 64bit Want a quotient using a constant to show up in column c each time a number is added to column b Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Hi
suppose your constant is in cell D1
In C1 enter
Code:
=IF($B1="","",$B1/$D$1)
Select column C
Go to the Home tab,clck Fill then Down
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #3  
Old 12-09-2014, 05:48 PM
fibbermcghee fibbermcghee is offline Want a quotient using a constant to show up in column c each time a number is added to column b Windows 7 64bit Want a quotient using a constant to show up in column c each time a number is added to column b Office 2007
Novice
Want a quotient using a constant to show up in column c each time a number is added to column b
 
Join Date: Dec 2014
Posts: 2
fibbermcghee is on a distinguished road
Default

Thanks, Pecoflyer

My columns and rows vary, but just substituting values worked a treat!

I'd like to mark this as solved, but I can't figure out how. Maybe someone else will.

Thanks again.

--fibbermcghee
Reply With Quote
Reply

Tags
2007, constant, spreadsheets

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Want a quotient using a constant to show up in column c each time a number is added to column b Parsing 'FullName' column - help needed text to column ScottA Excel Programming 3 05-06-2014 12:49 PM
Want a quotient using a constant to show up in column c each time a number is added to column b Automatically enter date into a column and make that column read only Mr Davo Excel 1 10-29-2012 01:07 AM
Can I change the horizontal scrollbar to scroll smoothly rather than column by column carpat Excel 0 01-10-2012 09:34 AM
Want a quotient using a constant to show up in column c each time a number is added to column b Need to search a column for a macth and return a result from a third column pdfaust Excel 2 02-03-2011 03:02 PM
Want a quotient using a constant to show up in column c each time a number is added to column b Last Number in a Column paulrm906 Excel 1 12-05-2008 07:51 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:34 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft