Question about Microsoft Office Standard for PC

1 Answer

Excel how do i link one cell of text to a number. For example, i choose one of many different models and i need to link the model i choose to the data i have found in another cell. If cell C54=PT6agj then cell C56=2.88 If cell C54=PT45jal then cell C56=2.6 and so on..

Posted by on


1 Answer

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 1 Answer

Why not do it directly with the if statement? ie In Cell c56 put the following formula: if(c54="PT6agi",2.88,if(c54="PT45jal",2.6,if(c54=....)))

Posted on Sep 11, 2007

  • Raymond Elixer Sep 11, 2007

    Just remember with the IF statement:
    1. You must make sure you close all the brackets at the end.
    2. each if statement has 2 commas after the first comma the value if the statement is TRUE and after the second the value if the statement is false - this can be another if.
    3. the last if statement must have the value that must be returned if none of the conditions apply. It would look like this:
    In this case it puts a blank in C56.

  • Raymond Elixer Sep 11, 2007

    That is a "1.2" not "1,2"



1 Suggested Answer

  • 2 Answers

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

A 6ya expert can help you resolve that 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.
The service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Good luck!

Posted on Jan 02, 2017


Add Your Answer

Uploading: 0%


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



Related Questions:


How can I create a Barcode for Free in Microsoft Excel?

<p>Placing barcode equipment or other things makes it easier to keep track of them. Instead of entering a long number, a quick scan with a bar code reader eliminates keystrokes. There are many different types of barcodes. The most famous is the Product Code or UPC Universal, in almost all items sold at retail in the United States. The UPC format only supports encryption of the songs. Other formats such as Code 39 (also known as Code 3 of 9) support letters and numbers. <br /> <p><br /> <p>1. Find a free TrueType font to the desired shape of the bar code. For example, the Code bar code format is 39 different TrueType font packages available free. Use an Internet search engine and type "Code 39 TrueType fonts" available in a free font found. Some specialized formats may not be available for free as a result of copyright or other restrictions. <br /> <p><br /> <p>2. On your Windows PC, select the Start menu and click Control Panel. Within the Control Panel, click Switch to Classic View "and appearance of the panel. Find the" Fonts "icon and double click to open it. On the File menu, select" Install New Font. "This opens a menu dialog asking you to change the font to install. Navigate to the folder that contains the downloaded TrueType font file. Select the font and click OK when prompted to install it. The source of new bar code will be available in Excel. <br /> <p><br /> <p>3. Start Excel and enter "98765" in cell A1. This value is converted to a bar. <br /> <p><br /> <p>4. In cell B1, type the following formula: "= CONCATENATE ("*", "*")" A1 and press enter. The result should be "* 98765 *". Code 39 format requires an asterisk at the beginning and end of the text to be encrypted. Bar code format other will have different rules. <br /> <p><br /> <p>5. Change the font in cell A1, choosing a different font from the drop-down menu at the top of the screen in Excel. Under the menu "Home", scroll down to "three of the nine free" source and select it. The text in the cell will now appear as a barcode. Increase font with a minimum of 28 points, so a scanner can pick up the scanning needs. <br />

on Jun 26, 2011 | Computers & Internet


Microsoft Excel tips

Auto sum shortcut key
Quickly create a Microsoft Excel formula to get the sum of all cells by highlighting the cells you wish to know the value of and pressing ALT and = .
Create hyper links in Excel
Quickly create hyper links in your Microsoft Word, Excel, or Front Page document by highlighting text and pressing "CTRL + K".
Close all open files at once
Close all open Microsoft Word and/or Excel files by holding down the shift key and clicking "File" and then "Close All".
Quickly open recently opened files
Quickly open the recent files by first pressing "ALT + F" to open the file Menu and press 1, 2, 3, or 4.
Create underlines without any text
This tip works with the majority of Microsoft Office applications. Easily create an underlined space by pressing CTRL + U to start the underline, then press SHIFT + Space for each underlined space you wish to create. An example of how this could be used is for printable forms, for example: Name: .
Print only sections of a document
Save on your printer ink by selectively printing in Windows programs such as Microsoft Word, Internet Explorer, WordPad, Outlook, etc. To do this highlight portions of text you wish to print and click print. In the printer dialog window under Page Range choose the option Selection. It is important to realize that not all programs or printer drivers support this feature.
Repeat recent action
Using the F4 key in Microsoft Office 2000 and above allows the user to repeat the last used action. For example, if you have changed the font of a selected text and wish to change another portion of text to the same font, pressing F4 will do this for you automatically.
Quickly undo
Quickly undo mistakes in the majority of most PC Windows program by pressing CTRL + Z.
Quickly above cell contents
In Microsoft Excel press CTRL + SHIFT + " to copy the above cells contents.
Using the Microsoft Excel Auto filter
Organize cells quickly by using Microsoft Auto filter. Columns that contains long listing of data can be easily sorted by using the Auto filter option, to use this option select the top rows of the columns you want to be used and select Data / Filter and Auto Filter. Once successfully completed you can use drop down arrows to filter the data automatically.

on Dec 27, 2009 | Computers & Internet

1 Answer

What is the "&" symbol for in excel 2010?

The "&" symbol is commonly known as "ampersand" and it is a calculation operator. Ampersand can be used in Excel 2010 to join text items from different cells. It functions much similar as "CONCATENATE" function. The output value you will get by using ampersand function will be the same as the one you will get by using CONCATENATE function. For example, =A1 & B1 returns the same value as=CONCATENATE(A1, B1)

To know more about the CONCATENATE/ ampersand function, you can refer to the following webpages:

(Important: Below mentioned link is of a third-party website. We recommend you to update your security software thoroughly before clicking on the link.)

(Important: Below mentioned link applies to Excel 2007. Still, you can refer it to understand more about ampersand function.)

Jul 30, 2014 | Microsoft Excel 2010

1 Answer

I want to find out what is meaning of cell in microsoft excel 2007 windows.

The rectangular box identified by a unique letter - number combination. You would type your number or text into this box.

A cell is the intersection of one row and one column. (EXAMPLE: A1, which refers to the cell made by the intersection of Column A and row 1.)

Nov 09, 2010 | Microsoft Office Excel 2007 Upgrade:...

1 Answer

Need Formula

Convert to UPPER, Proper or lower
Auto Convert to UPPER, Proper or lower
Stop VBA Being Case Sensitive

Select Case Statement. Great alternative to Else If Statements

VBA: CBool(),CByt(),CCur(),CDate(),CDbl()Double,CDec(),CInt(),CLng(),CSng(),CStr(),CVar().
Convert Numbers to Words
Convert Numbers to Dollar Amount in Words
Spreadsheet Converter. Versions: HTML/JavaScript,Excel ASP.Net and Excel Java/JSP. $
SQL Database Migration $
Converters. Database Converters, Spreadsheet Converters, Text Converters, E-mail Conversion, Document Conversion, PDF Conversion and more! $
CSV Converter $

Import SQL Into Excel-SQL Tester $
Import Excel Into Access $

Conditional Formatting
More Than 3 Conditional Formats
Conditional Format Fonts for greater than 3

Custom Formats
Excel see a cells format as having four Sections. These are, from left to right: Positives;Negatives;Zeros;Text.

To hide zeros cell-by-cell use a Custom Number Format like 0.00;-0.00; where 0.00 is desired format for non zeros. Note the use of -0.00 for negatives.

To hide zeros on the Workbook level go to Tools>Options>View - Zero Values.

Dec 15, 2008 | Microsoft Windows XP Home Edition

1 Answer

I want to link a word document to a cell in Excel

Dear nshrivas,

Type some text in a cell and select that cell then right click choose Hyperlink option then select the file which you want to link and click ok.....


Sep 24, 2008 | Microsoft Excel for PC

3 Answers

Excel formula help

formula for the keys or short curt for excel

Jul 15, 2008 | Microsoft Excel for PC

1 Answer

Excel Formula

Make sure that the cell is formatted as a number, not as text. (Right-click the cell, format cell, number, choose NUMBER.)

Dec 19, 2007 | Microsoft Excel for PC

2 Answers

Conversion from date to text formet

Block off the cells (or row or column) in question, right-click and choose FORMAT CELLS. In the NUMBER tab, choose TEXT. This will make your dates appear exactly as they are typed, and not allow Excel to reformat them.

Nov 18, 2007 | Computers & Internet

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

66 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2970 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18420 Answers

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

Answer questions

Manuals & User Guides