Question about Microsoft Office Excel 2003 for PC

2 Answers

Dear Sir in column A i have the following Column A Column B (ResultColumn C ) 1 5 5 -2 7 -7 3 -9 9 -4 -10 -10 5 -2 2 in Column C i need to get only the sign changed i.e. ''-'' or ''+'' accourdingly as appearing in Column A but Column B figure should as it is. is there any formula in MS Excel for the same Request you to kindly help in getting the same immediatley Thank you for your attention to this mail Venkataramu KS

Posted by on

  • ksramu76 Mar 14, 2009

    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

×

2 Answers

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 3 Answers

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

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that gotĀ 5 achievements.

    Governor:

    An expert whose answer gotĀ voted for 20 times.

    Hot-Shot:

    An expert who has answered 20 questions.

  • Expert
  • 189 Answers

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

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

Change true false to yes no in SQL Query


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")

Jul 15, 2013 | Business & Productivity Software

1 Answer

Sir i want know about the basic of the excel $ how to use thw formula of plus and minus plz rply me Thank you Regards shambhu pandey


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

Aug 03, 2010 | Microsoft Excel for PC

1 Answer

Merge 2 columns with 550 cells each all at once?


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

Jun 15, 2010 | Microsoft Office Excel 2007

1 Answer

Sumif function....


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.

Apr 11, 2009 | Microsoft Works 8.0 for PC

1 Answer

Dear sir, I have a data in different columns like a b c d e f g h i j k l m n o p q and I want to merge data in (of a b c d in a) of k l m n o in g pls help me to sort this.


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.
1ak+f4pj7cbm32cuniyi2gaaaaaelftksuqmcc

Mar 20, 2009 | Microsoft Office Excel 2003 for PC

1 Answer

Dues must show automatically


Can you not show as such

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

1 Answer

Need to use the VLOOKUP formula for more then one column


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

1 Answer

BASIC EXCEL FORMULA


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

Sep 29, 2008 | Microsoft Business & Productivity Software

1 Answer

Lookup,s


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.

Feb 03, 2008 | Microsoft Excel for PC

1 Answer

Need formula to get address block into columns


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

Not finding what you are looking for?
Microsoft Office Excel 2003 for PC Logo

Related Topics:

120 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18297 Answers

Sudeep Chatterjee
Sudeep Chatterjee

Level 3 Expert

3267 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...