Question about Microsoft Office Professional 2007 Full Version for PC
If you wanted to use a List of words and assign a number to each word:
Use a pre-set list (use Data Validation for best results)
Use as many columns as there are words in your list plus one.
If your list is Go, Stop, Pause then in the first cell write =IF(A1="Go","1","") in the second cell write =IF(B1="Stop","2","") in the third vell write =IF(C1="Pause","3","") in the fourth cell write =CONCATENATE(B1:D1) the cells holding the IF statements.
Note "" returns a blank cell, therefore Concatenating the cells will return only a single number.
Select the Columns with the IF Statements and Format - Hide. This will tidy up the working Spreadsheet.
The complex method (which I prefer not to use - creating long Linear Functions can be very difficult to get them right and to correct if wrong) would be to use a number of IF functions joined by the OR function in the one cell.
Posted on May 11, 2008
The simplest solution is to use the if function.
In your example you coudl use:
IF "girl" is in a1 then b2 would show as 1.
If anything else but "girl" is in a1 then b2 would show as 0.
Posted on Feb 26, 2008
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.
Posted on Jan 02, 2017
Tips for a great answer:
May 29, 2016 | The Computers & Internet
on Nov 11, 2013 | Microsoft Excel Computers & Internet
Jun 06, 2010 | Microsoft Excel for PC
Apr 27, 2009 | Microsoft Excel for PC
Dec 03, 2008 | Microsoft Office Professional 2007 Full...
Dec 03, 2007 | Microsoft Excel for PC
Nov 18, 2007 | Computers & Internet
108 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: