2 Resources for

cell a1

Subscribe to this listing via:
RSS
Email

Sponsored White Papers, Webcasts, and Downloads

TechRepublic Resources

A formula to return a formula in Excel???: I have a situation in which several hundreds of sheets in the same workbook require the same formula to be enterred. Is there a way short of building a function that I can enter the formula once in a 'Legend' sheet, and then use a reference to that cell in...; Tags: bubba_barnett@..., Cell, Cell A1, Sheet1; Discussion threads 2007-04-24
excel names: Is it possible to use as a reference to a named cell the contents of other cells?Cell A1 has been named as "lt", and A2 has lt as cell content. May I use in A3 a formula such as =UnknownFunction(A2) to get the contents of cell A1?Thanks.=INDIRECT(A2)This is the one...; Tags: cell; Discussion threads 2004-11-10

Additional Resources

Excel ~ Special Cell Formatting: Does anyone know how to format maybe even build a specialized format to apply to a specific Cell. For instance, I want a specific cell (A1) to capitalize anything that is entered into it (cell A1). (I don't want one cell to show the contents of another cell.)...; Tags: Microsoft Excel, patricia.lynn@..., cell, Cell; Discussion threads 2007-10-10
excel - keep previous cell data: I have a cell A1 that is updated every 5 seconds from data I receive from a DDE server (those data are just numbers between 0 and 10) What I need is to store every minute the number from A1 in order to keep historical data of those numbers. So...; Tags: evalweb@..., cell; Discussion threads 2007-08-01
Excel formula: Please help Value in Cell A1 is copied into cell B1 and new value is entered in A1B1 should now show old value of A1 plus new value of A1in other words B1=B1+A1How do I do this in Excel. Tried to use if statement, cant figure it outThanksYou will need...; Tags: ichu50, Microsoft Excel, software; Q&A 2005-08-20

Excel adding information from one cell to another cell: I have three different cells with words in them and i need to add them all into one cell. Is there a formula for this?examplecell a1 says happya2 sada3 madi want my end product to becell a1 saying happy sad mad thanks.; Tags: Microsoft Excel, happy_murray@..., cell; Discussion threads 2007-05-14
IS THERE A FORMULA TO REPEAT WHAT EVER IS IN A CELL?: I have to repeat the same information in a different cell. But instead of typing it twice, can I create a formula in the 2nd cell to repeat whatever is in the 1st. cell? Sometimes it will be a number and sometimes it will be text typed into the...; Tags: cell, suzanne_juszcyk@...; Discussion threads 2007-02-26
Anatomy of an Excel formula: Using functions to perform calculations: CorrectionsThe textIf you read this literally (A1 : D1, for example), it reads "the contents of every cell between A1 and B1, inclusive of A1 and B1". should readIf you read this literally (A1 : D1, for example), it reads "the contents of every cell between A1 and D1, inclusive...; Tags: hardware, lschell, Microsoft Excel,; Discussion threads 2005-08-23
Any Excel Gurus Out There?: hello all, is it possible to reference data from a merged cell into a single cell? and if so how? whenever i try it i get #VALUE in the single cell. any help with this would be greatly appreciatedre: merged cell referenceIf you're getting #value in the single cell, you...; Tags: Microsoft Excel, hull_max@..., cell, single cell, merged cell; Discussion threads 2007-07-11
Creating a dropdown list that coresponds to different cells: I would like to know how to create a drop down list for a specified set of values, I want these values to correspond to a different value for exampleRough Concrete corresponds to 0.8so when i select the name such as rough concrete the value 0.8 appears in a cell...; Tags: Johnmotson@..., cell; Discussion threads 2007-11-12
Excel argument/formula question: Let's say I have the POTENTIAL to have data in cellS A1, B1, C1 and D1. In cell E1 I want to add all four cells together. That's easy. Now in cell F1 I want to say take the total from E1 and divide it by the...; Tags: Rosstamon, Microsoft Excel, A1:D1, cell; Discussion threads 2007-07-13
microsoft ECXEL help: Please helpcell A1 to A5 has a text value and cell B1 to B5 has a number value, if cell B1 to B5 present a negative value how can i automatically transfer or populate that negative value to C column and also transfer the text that represent that negative value...; Tags: Microsoft Corp., russellte2002@..., cell; Discussion threads 2007-05-17
MICROSOFT EXCEL 2003: Can anyone help. IF THE LETTER "A" IS ENTERED INTO A CELL BETWEEN (A1:A40) THEN THE NUMBER Fig"1" IS PLACE IN CELLS (B1:B40) If another "A" IS ENTERED BETWEEN (A1:A40)THEN Fig "2" IS PLACE IN CELLS (B1:B40)AND SO ON NUMBERING CELLS IN SEQUENTIAL ORDER 3,4,5. SO IF THERE ARE 5...; Tags: A1:A40, arrays, B1:B40, buzby@..., excel, feedback, formulas, Microsoft Corp., Microsoft Excel, off-topic, programming, windows; Discussion threads 2007-01-19
Help with the IF Function in Excel: Hi, I am preparing a Tax Calculator using Excel but can't get the formula right. Here's an example:Gross annual income:Below 1000 should be tax free1000-2000 should pay 2202000-3000 should pay 330........above 10,000 should pay 1100 etc, etcI tried using the IF Function but still received errors. Urgent help is welcomed.Try...; Tags: mamahtm@..., software, Microsoft Excel; Q&A 2006-08-21
Autometic express of numeric value in text in MS exel.: Suppose in A1 cell a vale inserted 100 and in B1 another value 200 is inserted. Now If C1 cell represent A1+B1=C1 i,e, C1=300 then how this 300 value can autometically typed in text in another Cell D1 i,e, in D1 "Rupees Three Hundred Only" can autometically generate. Remember every...; Tags: rajusahantc@..., Microsoft Corp.; Discussion threads 2007-04-13
Excel: Auto Date Stamp: I have an excel spreadsheet that I would like to have cell A1 updated any time a change is made to cells A5:G116. I have played around with mutiple statments but each time I receive and error. In all honesty I am not a skilled VB writer, but...; Tags: Microsoft Office, jeff@..., Microsoft Excel, cell; Discussion threads 2007-08-27
Open excel File in A1 Cell: Hello:I have large file in excel. when I open the file the cursor opens where I left and save with. I need the cursor to open always begining cell A1. Is it possible?ThanksMDcan't you just go back to A1 when you save. You just have to press ctrl-home just before...; Tags: mdhislam@..., software, worksheet; Q&A 2006-05-04
VBA Please Help: I want to make a vba for excel that will look at the column to the left of the active cell and if there is a formula there drag it over to the right into the active cell and if there is not a formula there copy and paste it...; Tags: nsanyal@..., VBA, active cell, cell; Discussion threads 2007-03-28
date formulas in excel: i have a cell in worksheet number 1 that has a starting date for the first invoice of 60 subsequent invoices. i need to know how to have the same cell in each invoice calculate the future date based on the sequence of the worksheet. i.e. worksheet #2 would be...; Tags: cell, invoice; Q&A 2005-08-19
if condition: plz find the formula below=if(a1=1,"one",if(a1=2,"two",if(a1=3,"three","four")))but i need only one if two check all the conditionsLooks rightThe code works as expected when I pasted into a worksheet. Can you try to be more descriptive of your exact problem? Are you getting an error or unexpected results?; Tags: sureshchinna_sb@...; Discussion threads 2007-10-19

<< Previous
page 1 of 1
Next >>

Windows XP vs. Mac OS X: This presentation, entitled Standardizing on Windows XP Instead of MAC OS X, provides a pre-packaged option for defending Windows XP against MAC OS X. ...; Buy Now

First Look: Microsoft Office 2007: This presentation is based on Microsoft Office 2007 Beta 2 applications, offering a visual tour of some of the most significant enhancements. It is no ...; Buy Now