Search : in
By :

How to get cell value in formula

Last answer on Aug 10, 2009 6:31:38 am BST Arihant, on Aug 9, 2009 5:17:45 am BST 
 Report this message to moderators

Hello,

I am writing a formula where I need to get values of cell A1 and B1

I need below text in cell C1

create.put("A1","B1");

What formula shall I write in excel to achieve this.

Thanks in advance
Arihant

Configuration: Windows XP Internet Explorer 8.0

Best answers for « how to get cell value in formula » in :
Excel - Send value of cell to target ShowExcel - Send value of cell to target Issue Solution Note Issue Is it possible to send the value of a cell (copy and paste special) to another cell where the value would not be disturbed when the source value changes to '0'? My...
Basic Excel Formulas ShowBasic Excel Formulas Below are some basic formulas for Microsoft excel: Basic formula : ADDITION cell A1 to A10 = sum (A1: A10) AVERAGE cell A1 to A10 = average (A1: A10) MAXIMUM cell A1 to A10 = max (A1: A10) MINIMUM...
Colouring cells on conditions ShowColouring cells on conditions There are many pratical functions under Excel which is not commonly used. Example: If you wish a cell automatically turns red (or other formatting border, frame etc) under one condition: a result, a...
Worksheet - Cells ShowThe Concept of a Cell A "cell" is the intersection between a line (horizontal) and a column (vertical) on a worksheet. Thus, the name of the line combined with the name of the column gives the cell's coordinates (the term address is sometimes also...
Spreadsheet - Formulas ShowIntroduction to Formulas The main use of a spreadsheet is to automate calculations, which means using cells to perform operations based on values in other cells. The spreadsheet recalculates all the values each time a change is made to the value of...
Spreadsheets - Cell Selection ShowCell Selection Spreadsheets are powerful tools for working with data. However, to work with data, it is necessary to have tools to rapidly choose the required cells. Line Selection An entire line can be chosen by clicking directly on the line...
Ask your question Reply

1

 Guy, on Aug 10, 2009 6:31:38 am BST

Range("C3").Value = Range("A1") & Range("B1")

   
Reply to Guy
Ask your question Reply
They need your help