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

×

Ad

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

Ad
  • 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

Ad

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi there,
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.

Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.

Here's a link to this great service

Good luck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1 Answer

How do I replace the headlight switch in my 1999 chevy prism


Headlamp Switch Replacement

Removal Procedure



    Click to Enlarge
    Warning!This vehicle is equipped with a Supplemental Inflatable Restraint (SIR) System. Failure to follow the correct procedure could cause the following conditions:
    • Air bag deployment
    • Personal injury
    • Unnecessary SIR system repairs
    In order to avoid the above conditions, observe the following guidelines: • Refer to SIR Component Views in order to determine if you are performing service on or near the SIR components or the SIR wiring.
    • If you are performing service on or near the SIR components or the SIR wiring, disable the SIR system. Refer to Disabling the SIR System.
  1. Disable the SIR System. Refer to Disabling the SIR System in SIR.
  2. Important It is not necessary to remove the steering wheel to access the lower trim cover screws. The screws can be easily accessed by rotating the steering wheel.
  3. Remove the following components from the steering column:
  4. - The lower trim cover screw
    - The 2 lower trim cover screws (2) that are located beneath the steering wheel (1).


    Click to Enlarge
  5. Remove the steering column lower trim cover (6).


  6. Click to Enlarge
  7. Remove the following components from the steering column:
  8. - The steering column upper trim cover screw (3)
    - The steering column upper trim cover (2)


    Click to Enlarge
  9. Inspect the base (1) for damage. If damage to the base is observed, replace the turn signal, headlamp and windshield washer switch as an assembly. Refer to Inflatable Restraint Steering Wheel Module Coil Replacement in SIR.
  10. Disconnect the turn signal/headlamp switch electrical connector (3).
  11. Remove the following components from the steering column:
  12. - The 2 screws (4)
    - The turn signal/headlamp switch (2)

    Sorry in copy, read only, no pictures. I'd check voltage and ground for headlamps, first.

May 04, 2018 | Cars & Trucks

1 Answer

Replacing turn signal switch on 1993 chevy astro


To Remove:
  1. Disable the SIR system. (See section on SIR Precautions)
  2. Remove the steering wheel from the steering column. (See section on Steering Wheel)
  3. Remove the steering column trim covers.
  4. Remove the wire harness straps from the wire harness assembly.
  5. Disconnect the multifunction switch/SIR coil assembly connector from the base of the column.
  6. Remove the multifunction switch/SIR coil assembly lead from the wire harness assembly.
  7. Remove the 3 pan head tapping screws from the multifunction switch/SIR coil assembly.
  8. Slide the multifunction switch/SIR coil assembly off of the steering column.

Hope this helps. Be very careful where airbag is involved.

Apr 08, 2018 | Chevrolet Astro Cars & Trucks

1 Answer

How to remove steering column on a 2005 Buick LeSabre


Steering Column Replacement Hope this helps?

Tools Required

• J 42640 Steering Column Lock Pin
• J 41352 Modular Column Holding Fixture

Removal Procedure

    Warning! Refer to SIR Caution in Cautions and Notices.
    Caution! The wheels of the vehicle must be straight ahead and the steering column in the LOCK position before disconnecting the steering column or intermediate shaft from the steering gear. Failure to do so will cause the SIR coil assembly to become uncentered, which may cause damage to the coil assembly.
    Caution! Once the steering column is removed from the car, the column is extremely susceptible to damage. Dropping the column on its end could collapse the steering shaft or loosen the plastic injections which maintain column rigidity. Leaning on the column could cause the jacket to bend or deform. Any of the above damage could impair the column's collapsible design. If it is necessary to remove the steering wheel, use only the specified steering wheel puller. Under no conditions should the end of the shaft be hammered upon as hammering could loosen plastic injections which maintain column rigidity.
  1. Disable the SIR system. Refer to SIR Disabling and Enabling Zone 3 in SIR.



  2. Insert J 42640 into the steering column access hole in order to lock the steering column. This will maintain the correct orientation.
  3. Raise and support the vehicle. Refer to Lifting and Jacking the Vehicle in General Information.



  4. Remove the intermediate shaft lower pinch bolt.
  5. Remove the intermediate shaft from the steering gear.
  6. Lower the vehicle.



  7. Remove the knee bolster. Refer to Bracket Replacement - Knee Bolster in Instrument Panel, Gages and Console.
  8. Disconnect the steering column wiring harness connector from the main body wiring harness.
  9. Disconnect the shift lever cable from the linear shift assembly.



  10. Remove the shift cable retaining clip.



  11. Press the shift cable tabs (1) together and remove the shift cable (2) from the steering column.



  12. Caution! The steering column should never be supported only by the lower support bracket. Damage to the lower support could result.
    Important Stabilize the studs in order to remove the nuts securing the steering column to the instrument panel.
  13. Support the column.



  14. Remove the lower steering column retaining nuts.
  15. Remove the upper steering column retaining nuts.
  16. Important Discard the clips at the upper steering column support, if equipped. These clips are for assembly plant usage only.
  17. Remove the steering column from the vehicle.
  18. Install the steering column into J 41352 .

Jan 06, 2018 | Buick LeSabre Cars & Trucks

1 Answer

How do i remove the ignition lock ccylinde on a 2002 buick lasaber


Removal Procedure
Caution: This vehicle is equipped with a Supplemental Inflatable Restraint (SIR) System. Failure to follow the correct procedure could cause the following conditions:
• Air bag deployment
• Personal injury
• Unnecessary SIR system repairs
In order to avoid the above conditions, observe the following guidelines:
• Refer to SIR Component Views in order to determine if you are performing service on or near the SIR components or the SIR wiring.
• If you are performing service on or near the SIR components or the SIR wiring, disable the SIR system. Refer to Disabling the SIR System.
Disable the SIR system. Refer to Disabling the SIR System in SIR.
Caution: Unless directed otherwise, the ignition and start switch must be in the OFF or LOCK position, and all electrical loads must be OFF before servicing any electrical component. Disconnect the negative battery cable to prevent an electrical spark should a tool or equipment come in contact with an exposed electrical terminal. Failure to follow these precautions may result in personal injury and/or damage to the vehicle or its components.
Disconnect the battery negative cable. Refer to Battery Negative Cable Disconnection and Connection in Engine Electrical.
Position the steering wheel half way between the upper and lower tilt stops, if necessary.
Remove the steering wheel. Refer to Steering Wheel Replacement .
Remove the tilt lever. Refer to Tilt Lever Replacement - On Vehicle .

Remove the lower steering column trim cover retaining screws.
Remove the lower steering column trim cover.

Remove the upper steering column trim cover retaining screws (3).
Buick Ignition Lock Cylinder Replacement

Nov 09, 2016 | Buick Cars & Trucks

1 Answer

How to replace steering wheel position sensor on a 2006 Cadillac DTS?


Manual Steering Column with JL4) or
Steering Wheel Position Sensor Replacement (Power Steering Column with JL4) ?
Preliminary Procedure Remove the intermediate steering shaft. Refer to Intermediate Steering Shaft Replacement .
1
Steering Angle Sensor Adapter
2
Steering Wheel Position Sensor
Procedure Disconnect any electrical connectors as needed.
Tip
If reusing, secure the old steering wheel position sensor before removing it for proper alignment upon reinstallation. Refer to Steering Wheel Position Sensor Centering .

Callout

Component Name
Notice: Secure the steering wheel utilizing a strap to prevent rotation. Locking of the steering column will prevent damage and a possible malfunction of the SIR system. The steering wheel must be secured in position before disconnecting the following components:
?€¢
The steering column
?€¢
The intermediate shaft
?€¢
The steering gear

After disconnecting these components, do not move the front tires and wheels. Failure to follow these procedures may cause improper alignment of some components during installation and result in possible damage to the SIR coil.
Preliminary Procedure Remove the steering column. Refer to Steering Column Replacement .
1
Intermediate Steering Shaft Bolt
Procedure Remove the steering column boot seal in order to access the intermediate steering shaft bolt.
2
Intermediate Steering Shaft Nut
Notice: Refer to Fastener Notice in the Preface section.
Tighten
47 N?·m (35 lb ft)
3
Intermediate Steering Shaft
Tip
?€¢
If necessary, scribe location marks between the intermediate steering shaft and the steering column and the intermediate steering shaft and the steering gear to mark their alignment before removing.
?€¢
If replacing the intermediate steering shaft, transfer any scribe marks from the old one to the new one.

Callout

Component Name
Notice: Secure the steering wheel utilizing a strap to prevent rotation. Locking of the steering column will prevent damage and a possible malfunction of the SIR system. The steering wheel must be secured in position before disconnecting the following components:
?€¢
The steering column
?€¢
The intermediate shaft
?€¢
The steering gear

After disconnecting these components, do not move the front tires and wheels. Failure to follow these procedures may cause improper alignment of some components during installation and result in possible damage to the SIR coil.
Preliminary Procedures

  1. Remove the left side instrument panel insulator panel. Refer to Instrument Panel Insulator Panel Replacement - Left Side .
  2. Remove the driver knee bolster. Refer to Driver Knee Bolster Replacement .
  3. Disconnect the intermediate steering shaft from the steering gear. Refer to Steering Gear Replacement .
1
Steering Column Nut (Qty: 4)
Notice: Refer to Title not found in the Preface section.
Tighten
25 N?·m (18 lb ft)
2
Steering Column
Procedure
  • Disconnect any electrical connectors as needed.
  • If equipped with AN3, disconnect the automatic transmission range selector cable. Refer to Automatic Transmission Range Selector Cable Replacement - Column .
  • Transfer any parts as needed.
  • Sep 12, 2015 | Cadillac Cars & Trucks

    1 Answer

    Need to change the ignition switch


    Steering Column Trim Cover Replacement
    Removal Procedure
    Caution: Refer to SIR Caution in the Preface section.
    1. Disable the SIR system. Refer to SIR Disabling and Enabling in SIR.
    2. Caution: Unless directed otherwise, the ignition and start switch must be in the OFF or LOCK position, and all electrical loads must be OFF before servicing any electrical component. Disconnect the negative battery cable to prevent an electrical spark should a tool or equipment come in contact with an exposed electrical terminal. Failure to follow these precautions may result in personal injury and/or damage to the vehicle or its components.
    3. Disconnect the battery negative cable. Refer to Battery Negative Cable Disconnection and Connection in Engine Electrical.
    4. Remove the steering wheel. Refer to Steering Wheel Replacement .
    5. Remove the gap hider. Refer to Instrument Cluster Replacement in Instrument Panel, Gages, and Console.
    Put the steering column in the CENTER position. Remove the tilt lever (1).
    Remove the retaining screws (3) from the lower steering column trim cover. Disconnect the closeout trim cover from the lower steering column trim cover.
    Remove the retaining screw (2) from the upper steering column trim cover (1).

    Sep 10, 2015 | 2004 Buick LeSabre

    1 Answer

    Highbeam switch


    1. If equipped, disable the SIR system. Disconnect the negative battery cable.
    2. Remove the upper steering column cover.
    3. Remove the lower steering column cover screws and lower the steering column cover.
    4. Remove the 2 switch mounting screws and remove the switch.
    5. Detach all wire connectors from the combination switch. Push locking tabs to remove the wires.

    To install:

    1. Attach all wire connectors to the combination switch.
    2. Install the combination switch to the column with the 2 attaching screws.
    3. Install the lower steering column cover screws and lower steering column cover.
    4. Install the upper steering column cover and attaching screws.
    5. Connect the negative battery cable.
    6. Enable the SIR system, if equipped.

    Dec 04, 2011 | 1999 Pontiac Sunfire

    2 Answers

    How to replace the turn signal switch in a 1992 Cadilac?


    Turn Signal Switch REMOVAL & INSTALLATION CAUTION
    Some models covered by this manual may be equipped with a Supplemental Restraint System (SRS), which uses an air bag. Whenever working near any of the SRS components, such as the impact sensors, the air bag module, steering column, and instrument panel disable the SRS. Deville, Eldorado, Seville, and Fleetwood - Early Models
    1. Disable the SIR system.
      1. On Deville and Fleetwood, remove the left lower sound insulator. On Eldorado and Seville, remove the left side sound insulator.
      2. Remove the Connector Position Assurance (CPA) and detach the yellow 2-way connector at the base of the steering column.
      3. Remove the steering wheel.
      4. Make sure the ignition switch is in the LOCK position to prevent the SIR coil assembly from going off-center.
    2. Remove the SIR coil assembly retaining ring and the coil assembly. Allow the coil to hang freely. WARNING
      The SIR coil assembly will become off-center if the steering column is separated from the steering gear and is allowed to rotate or if the centering spring is pushed down, letting the hub rotate while the coil is removed from the column.
    3. Remove the wave washer.
    4. Use tool J-23653-C or equivalents, to depress the shaft lock, then remove and discard the shaft lock retaining ring.
    5. Remove the shaft lock.
    6. Remove the turn signal canceling cam assembly.
    7. Remove the upper bearing spring, upper bearing inner race seat and inner race.
    8. Move the turn signal switch to the RIGHT TURN position.
    9. On Deville, Fleetwood, and 1990 Eldorado, and Seville, remove the multi-function turn signal lever as follows:
      1. Make sure the lever is in the OFF position.
      2. Remove the access cover from the steering column housing.
      3. Detach the cruise control wiring connector. Note the position of the connector when installed in the column.
      4. Pull the lever straight out of the turn signal switch.
    10. On Eldorado and Seville, remove the multi-function turn signal lever as follows:
      1. On 1992-93 vehicles, slide the connector cover toward the front of the vehicle.
      2. Unplug the electrical connector. On 1991 vehicles, note the position of the connector when installed in the column.
      3. Push the lever straight in, rotate clockwise 1?4 turn and pull the lever out of the switch.
    11. On Deville, Fleetwood, and Eldorado and Seville, remove the screw, button, spring, and hazard warning switch knob.
    12. On Deville and Fleetwood, remove the one signal switch arm retaining screw. On Eldorado and Seville, remove the 2 signal switch arm retaining screws. Remove the signal switch arm.
    13. Remove the turn signal switch retaining screws.
    14. Remove the wiring protector and detach the turn signal switch connector.
    15. Gently pull the wire harness through the column and remove the turn signal switch. prev.gif next.gif

    Nov 12, 2010 | 1992 Cadillac DeVille

    1 Answer

    Do you have to teach your computer on1998cavalier when replacing ingition switch


    I don't think so: Ignition Switch REMOVAL & INSTALLATION Fig. 1: Ignition switch mounting 87958063.gif
    CAUTION
    The Supplemental Inflatable Restraint (SIR) system must be disarmed before working around the steering column. Failure to do may cause accidental deployment of the air bag, resulting in unnecessary SIR system repairs and/or personal injury.
    1. Disconnect the negative battery cable.
    2. If equipped, disable the SIR system.
    3. Remove the steering column.
    4. The ignition switch is located at the base of the steering column. Disconnect the vehicle wire harness from the ignition switch.
    5. Unfasten the mounting screws, then remove the ignition switch assembly. To install: WARNING
      When fasteners are removed, always reinstall them at the same location from which they were removed. If a fastener needs to be replaced, use the correct part number fastener for that application. If the correct part number is not available, a fastener of equal size and strength (or stronger) may be used. Fasteners that are to be reused, and those requiring thread locking compound will be called out. The correct torque value must be used when installing fasteners that require it. If the above conditions are not followed, parts or system damage could result.
    6. Position the ignition switch assembly.
    7. Install and tighten the 2 mounting screws.
    8. Connect the vehicle wire harness to the switch assembly.
    9. Install the steering column.
    10. Enable the SIR system.
    11. Connect the negative battery cable.
    prev.gif next.gif

    Sep 18, 2010 | 1998 Chevrolet Cavalier

    2 Answers

    Got a 2000 chevy 3500 express van how do i get the old ignition switch out to replace it


    remove the steering wheel , need a puller and locking ring tool, disconnect batt, turn the key to tho on position, and remove bolt that holds the tumbler in,

    Nov 13, 2009 | 2000 Chevrolet 3500

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

    122 people viewed this question

    Ask a Question

    Usually answered in minutes!

    Top Microsoft Computers & Internet Experts

    micky dee

    Level 3 Expert

    3007 Answers

    Les Dickinson
    Les Dickinson

    Level 3 Expert

    18424 Answers

    Alun Cox

    Level 3 Expert

    2678 Answers

    Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

    Answer questions

    Manuals & User Guides

    Loading...