Microsoft Excel - Can you have a formula applied to cell where you enter data?

poldim · 04-16-2007, 05:13 PM

Basically, if I want to enter the year 2004 in cell A1 (and the rest of the A column), can I have excel perform a computation with that data entry, 2004, and return a result in that cell? I basically just want to avoid having an extra column.

RedStripe · 04-16-2007, 05:14 PM

Nope. Don't think so. You can always hide the column.

Stellvertreter · 04-16-2007, 05:36 PM

not sure if that helps but you can do the following for example: having 2004 in many cells in the A column... you can copy the value of another cell (for example the number 23 from C5) and then mark all cells in column A, paste special, multiply (or some other operation). This would multiply all cells in column A with 23 and returns the result within the cells in column A.

poldim · 04-16-2007, 05:47 PM

Its a data sheet for a group of fraternity members, I dont want to have a column that has "Graduating Year" and another one for "Academic Level". Hiding just makes it a pain in the ass for exporting to html and have the column elsewhere (like further to the right as column ZZ) just makes it a pain in the ass for data entry.

Ninjaneer · 04-16-2007, 07:51 PM

Put your data in column A on Sheet1, use Sheet2's column A to perform the calculations (which reference Sheet1's Column A values) and export Sheet2 to HTML.

poldim · 04-16-2007, 08:09 PM

Quote:

Originally Posted by Ninjaneer

Put your data in column A on Sheet1, use Sheet2's column A to perform the calculations (which reference Sheet1's Column A values) and export Sheet2 to HTML.

Thats equally as troublesome. I wont be the one entering the therefor I want to make it simple enough to enter for the people performing the modifications.

If I have cell A1 with entered data and cell A2 performing a calculation such as "=year(A1-4)", can I have it show absolutely nothing unless there is something entered in A1? I'd basically want to protect certain cells (that would be calculated) from modification. But it I protect them I'd want someone to be able to copy the cells so that newer members can be added.

Ninjaneer · 04-16-2007, 08:27 PM

Quote:

Originally Posted by poldim

If I have cell A1 with entered data and cell A2 performing a calculation such as "=year(A1-4)", can I have it show absolutely nothing unless there is something entered in A1? I'd basically want to protect certain cells (that would be calculated) from modification. But it I protect them I'd want someone to be able to copy the cells so that newer members can be added.

Try this in A2: =IF(A1,YEAR(A1-4),"")
The "" will make it show nothing (emptry string) if the field you read from is blank.

04-16-2007, 05:13 PM	#1
poldim Vroom Vrrooooom 300 Rep 3,146 Posts Drives: 330i Join Date: Oct 2005 Location: Bay Area, CA iTrader: (2) Garage List 2006 330i Sedan [0.00] 2003 GSX-R 600 [0.00]	Microsoft Excel - Can you have a formula applied to cell where you enter data? Basically, if I want to enter the year 2004 in cell A1 (and the rest of the A column), can I have excel perform a computation with that data entry, 2004, and return a result in that cell? I basically just want to avoid having an extra column. __________________ -Dmitriy 06' BMW 330i & 03' Suzuki GSX-R600 SG \| Beige Dakota \| Poplar \|\| iDrive w/MP3 \| PP \| SP \| CWP \| PDC \| Comfort \| Shades \|\| 40% Tint \| Black Line Tail Lights \| Hardwired V1
	Appreciate 0 Tweet Quote

04-16-2007, 05:14 PM	#2
RedStripe Captain 96 Rep 649 Posts Drives: 2006 BMW 325i Join Date: May 2005 Location: Texas iTrader: (1) Garage List 2006 BMW 325i [0.00]	Nope. Don't think so. You can always hide the column.
	Appreciate 0 Quote

04-16-2007, 05:36 PM	#3
Stellvertreter Autobahn User ;) 11 Rep 25 Posts Drives: BMW E92, 330dA xDrive Join Date: Apr 2007 Location: Frankfurt (Germany) iTrader: (0)	not sure if that helps but you can do the following for example: having 2004 in many cells in the A column... you can copy the value of another cell (for example the number 23 from C5) and then mark all cells in column A, paste special, multiply (or some other operation). This would multiply all cells in column A with 23 and returns the result within the cells in column A.
	Appreciate 0 Quote

04-16-2007, 05:47 PM	#4
poldim Vroom Vrrooooom 300 Rep 3,146 Posts Drives: 330i Join Date: Oct 2005 Location: Bay Area, CA iTrader: (2) Garage List 2006 330i Sedan [0.00] 2003 GSX-R 600 [0.00]	Its a data sheet for a group of fraternity members, I dont want to have a column that has "Graduating Year" and another one for "Academic Level". Hiding just makes it a pain in the ass for exporting to html and have the column elsewhere (like further to the right as column ZZ) just makes it a pain in the ass for data entry. __________________ -Dmitriy 06' BMW 330i & 03' Suzuki GSX-R600 SG \| Beige Dakota \| Poplar \|\| iDrive w/MP3 \| PP \| SP \| CWP \| PDC \| Comfort \| Shades \|\| 40% Tint \| Black Line Tail Lights \| Hardwired V1
	Appreciate 0 Quote

04-16-2007, 07:51 PM	#5
Ninjaneer Shadow Warrior 139 Rep 2,095 Posts Drives: '07 335i Sedan Join Date: Aug 2006 Location: Florida iTrader: (0)	Put your data in column A on Sheet1, use Sheet2's column A to perform the calculations (which reference Sheet1's Column A values) and export Sheet2 to HTML. __________________ 335i E90 / Arctic / Gray / Burl Walnut / Steptronic / ZPP / ZSP / Paddles / CA / Nav / PDC / OEM Spoiler Mods: PIAA Angel Eyes, Rear Fog Switch, Escort X50 Blue hardwire, 30% Charcoal Llumar Installing soon: Rear Power Outlets (Happy Robot mod!)
	Appreciate 0 Quote

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search