Question about Microsoft Office Excel 2003 for PC

If I understand you correctly, you are trying to reverse the sign on a column of numeric data in Excel. You should be able to use a formula in your results column (Column C?) that looks like this: =(A1*-1) That formula should reverse the sign of the values in column A.

Posted on Mar 18, 2009

Put the below formula in column C1 and then drag down for other values. Please rate me if this helps. please.

=(A1* -1)

Posted on Mar 12, 2009

This depends on the flavor of SQL you're using. If your column for true/false is boolean then the following would be one method:

SELECT CASE [Column] WHEN true THEN 'Yes' ELSE 'No' END

for something like MS Access:

=IIF(Column = True, "Yes", "No")

SELECT CASE [Column] WHEN true THEN 'Yes' ELSE 'No' END

for something like MS Access:

=IIF(Column = True, "Yes", "No")

Jul 15, 2013 | Business & Productivity Software

1. Make sure you have entered the numbers you'll need in necessary columns

2. Go to the column you would want the results to appear in

Guide: + (addition); -(subtraction); *(multiplication); /(division)

3. Type in =(select a cell)+ (Select the other cell) - (select the appropriate cell) and so on

4. If you are looking for a sum of try this formula, SUM=(select the first cell in the roll or column, hold the shift key and select the last number) then press enter

2. Go to the column you would want the results to appear in

Guide: + (addition); -(subtraction); *(multiplication); /(division)

3. Type in =(select a cell)+ (Select the other cell) - (select the appropriate cell) and so on

4. If you are looking for a sum of try this formula, SUM=(select the first cell in the roll or column, hold the shift key and select the last number) then press enter

Aug 03, 2010 | Microsoft Excel for PC

Merging Columns In Excel
Now that we've clarified what merging columns actually means, we can explore how to do it. The first step is to perform the merge for the first cells. Let's go back to our first example and suppose that we are merging column A that contains first names with column B that contains second names. We'll put the merged columns into column C. To merge cell A1 with cell B1 we woul type the following into cell C1:=A1&" "&B1

paste this into C1 (or where needed)

=A1&" "&B1

paste this into C1 (or where needed)

=A1&" "&B1

Jun 15, 2010 | Microsoft Office Excel 2007

Use the following formula as an array formula, you need to hit "Shift+Ctrl+Enter" after entering the formula. Lets say you have the Name in column "B", the Age in column "C" and the amount paid in column "D". Here is the formula.

=SUM((B2:B7="Abhilash")*(C2:C7>0)*(D2:D7))

It will calculate the amount paid if the name =Abhilash" and the Agr is greater than zero.

=SUM((B2:B7="Abhilash")*(C2:C7>0)*(D2:D7))

It will calculate the amount paid if the name =Abhilash" and the Agr is greater than zero.

Apr 11, 2009 | Microsoft Works 8.0 for PC

in** Column A** put this formula:

**=CONCATENATE(B1,C1,D1)**

and in** Column G** put this formula:

**=CONCATENATE(K1,L1,M1,N1,O1)**

P.S.: If this information was helpful, please rate this solution.

and in

P.S.: If this information was helpful, please rate this solution.

Mar 20, 2009 | Microsoft Office Excel 2003 for PC

Can you not show as such

Dues= Column A

Paid = Column B

Outstanding Column C

A-B=C

total Column C = Total Outstanding

Dues= Column A

Paid = Column B

Outstanding Column C

A-B=C

total Column C = Total Outstanding

Jan 18, 2009 | Microsoft EXCEL 2004 for Mac

You probably need to organise your pricelist sheet so that you only have 2 columns, product and price. If this doesn't fix you, please provide the syntax of your vlookup code.

Dec 10, 2008 | Microsoft Excel for PC

Are you looking to solve any particular problem?--- because there are a huge number of possible formulas in Excel.

However, in my opinion, the most commonly needed ones are addition, subtraction, division, multiplication, and summing.

Suppose you have the following numbers typed into your Excel spreadsheet:

**columns: A B C D**

**rows**

**1 ** 20 3

**2 ** 10 4

**3 ** 15 2

**4 ** 1 2 3

Then suppose you type in the following formulas (in the D column):

**columns: A B C D**

**rows**

**1 ** 20 3 =A1+B1

**2 ** 10 4 =A2-B2

**3 ** 15 2 =A3*B2

**4 ** 1 2 3 =sum(A4:C4)

Then the following answers will appear in the D column:

**columns: A B C D**

**rows**

**1 ** 20 3 23

**2 ** 10 4 6

**3** 15 2 30

**4** 1 2 3 6

However, in my opinion, the most commonly needed ones are addition, subtraction, division, multiplication, and summing.

Suppose you have the following numbers typed into your Excel spreadsheet:

Then suppose you type in the following formulas (in the D column):

Then the following answers will appear in the D column:

Sep 29, 2008 | Microsoft Business & Productivity Software

If you can move your name column (C) to the first column, you could leverage the VLOOKUP formula pretty easily.

To do this, do the following:

1) Move the C Column to be the A Column, shifting all other columns to the right.

2) (optional) Insert a new row at the top of the sheet (to hold the formula & seach value)

3) Use A1 as your search field.

4) In A2, enter the following formula:

=VLOOKUP($A$1,$A$2:$C$6,3,)

Describing above parameters, in the formula:

$A$1 -> the search field (name your looking for).

$A$2:$C$6 -> The table/grid you wish to search and return values from. The left most column (A) must contain the values to be searched.

3 -> is the column number (A=1,B=2,C=3, etc) within the table/grid to return.

If you cannot make the name column your first (A) column, there are more complex ways to do this. For instance, create a new sheet which redisplays the info in the structure easier for this method, and perform the VLOOKUP on that data. Other options might exist in creating a complex formula that would get you what you want.

Also, if you can sort column A (names) it would find results faster, if your data set is large.

To do this, do the following:

1) Move the C Column to be the A Column, shifting all other columns to the right.

2) (optional) Insert a new row at the top of the sheet (to hold the formula & seach value)

3) Use A1 as your search field.

4) In A2, enter the following formula:

=VLOOKUP($A$1,$A$2:$C$6,3,)

Describing above parameters, in the formula:

$A$1 -> the search field (name your looking for).

$A$2:$C$6 -> The table/grid you wish to search and return values from. The left most column (A) must contain the values to be searched.

3 -> is the column number (A=1,B=2,C=3, etc) within the table/grid to return.

If you cannot make the name column your first (A) column, there are more complex ways to do this. For instance, create a new sheet which redisplays the info in the structure easier for this method, and perform the VLOOKUP on that data. Other options might exist in creating a complex formula that would get you what you want.

Also, if you can sort column A (names) it would find results faster, if your data set is large.

Feb 03, 2008 | Microsoft Excel for PC

If you are using MS Excel then use Text to Columns from the Data menu. Simply select the column then from the Data menu click Text to Columns & follow the simple instructions in the Dialog/Wizard.

Oct 11, 2007 | Microsoft Office Standard for PC

May 16, 2014 | Microsoft Office Excel 2003 for PC

120 people viewed this question

Usually answered in minutes!

Dear Sir/Madam

Thanks a lot for the formula and support. Its working. Very greatful.

I have one more query.

I have a repeated names/ values in one column and next to that column different values in Sheet 1 . I another sheet called sheet 2 and i have set of repeated names/values. I want to get the value from Sheet 1 for all repeated & Uniuqe name/values. For Example

Sheet 1

Name

Value

A

1

B

2

C

3

D

4

A

5

A

6

Sheet 2

Name Values

A

B

C

D

A

In sheet 2 i have to get the values from Sheet 1. In sheet 2 there is unique and repeated names.

How do i get the value, is there any formula to slove this.

Please help in getting this formula.

Thank you for your attention to this mail.

Venkataramu KS

×