Question about Microsoft Excel for PC

1 Answer

How to change a word to afigure automaticll if change in excel sheet

Posted by on

  • Gerald Russell
    Gerald Russell May 11, 2010

    could you give me an example?



    do you mean if I change value in column B to "Joe" change the value in column C to 200? (or "john" = 300 etc.)?

×

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Vice President:

    An expert whose answer got voted for 100 times.

  • Expert
  • 407 Answers

There are lots of ways of doing this - But it depends on how complex your fomula needs to be, or it may be a case of changing the format of the cell..

IF function will work well for a small range
LOOKUP will work well for a larger range assuming there will be duplications

Posted on May 22, 2009

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1 Answer

My excel is starting right to left in window 7


The default worksheet direction in Excel 2007 or 2010 is Left-to-Right. To change a worksheet direction to Right-to-Left, follow these steps:
  1. In Excel Ribbon click on the Page Layout tab.
  2. In the Sheet Options group click Sheet Right-to-Left. The sheet direction will be changed. Column A will now be to the far right. Columns B, C, D.. etc. will follow to the left.
xl10rtl1-300x53.jpg
- See more at: http://www.exceldigest.com/myblog/2012/04/29/how-to-change-worksheet-direction-in-excel-2010-to-right-to-left/#sthash.lSG25YXq.dpuf

May 27, 2014 | Microsoft Excel 2010

1 Answer

How to sende information from a sheet to another?


You can link to the original sheet or copy and paste - Linking might be easier as you only have 10. - Can you not use worksheets rather than excel. If you want to make it more autonomous you can index or look up the first sheet so any changes you make will be reflected back in your employee sheets.

May 26, 2009 | Microsoft Office Excel 2003 for PC

1 Answer

Unprotect an Excel sheet


Print or convert it to pdf then you may copy/paste from the pdf to a new unprotected sheet.

Doesnt work for formula.

Feb 18, 2009 | Business & Productivity Software

4 Answers

How to connect one sheet to another sheet


how i connect one excel sheet to another excel

Dec 21, 2008 | Microsoft Office Excel 2003 for PC

1 Answer

Need a formula for excel


select CONDITIONAL FORMATING in Format

select FORMULA IS , CELL VALUE = > < (condition)

after this select Format

font style , COLOR

SEE IT WILL WORK CHANGE OF COLOURS ........

Oct 10, 2008 | Microsoft Excel for PC

1 Answer

Excel problem


Is the stock register an excel spreadsheet?

May 10, 2008 | Business & Productivity Software

4 Answers

How to Export trial Balance from Tally 9.2 version to Excel sheet


you select the trial balace--and press Alt+E or click export---then the export details screen came,

Language: Default(all language)
Format: Excel (spreadsheet)
Output file name: trial bal.xls (any name you select)

Excel (spreadsheet) formating: yes
other details you select and accept the screen. then minimise or close the Tally, you open the tally file name at my computer. at the time you can see the file trialbal.

Mar 20, 2008 | Business & Productivity Software

2 Answers

How to Crack Excell sheet's Password


http://www.straxx.com/excel/password.html

Mar 03, 2008 | Business & Productivity Software

1 Answer

How can i change my old excel sheet password


Dear shiltu, you first have to remove your password. Press the old password and have access to the document. Now remove the password. Set new password and save it. You're done :)

if that has helped you please press fixya.

Dec 22, 2007 | Microsoft Excel for PC

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

Related Topics:

34 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...