Question about Microsoft Office Professional 2007 Full Version for PC

Ad

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)

Easy method:

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.

Good luck.

Posted on May 11, 2008

Ad

An2net21,

The simplest solution is to use the if function.

In your example you coudl use:

=IF(A1="girl",1,0)

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

Ad

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

The problem is not from the phone, be sure that the phones network is alright once you can send text messages to other numbers, then the problem is from the certain number you are trying to send it to, probably the persons phones service center number is not properly setted, or the number does not permit to receive text messages. But if you cannot send text message to any number, then it means the problem is from your phone and all you have to do is to set your service center number.

To do that, go to your phones menu, select the messages and go to its settings, then you check for your service center number, if it is correctly entered on the phone. If not, check for your operatives service center number and enter it correctly.

That should do the job for you.

To do that, go to your phones menu, select the messages and go to its settings, then you check for your service center number, if it is correctly entered on the phone. If not, check for your operatives service center number and enter it correctly.

That should do the job for you.

Jan 10, 2011 | LG Ally Cell Phone

Correct a #N/A error
Show All
Hide All
This error occurs when a value is not available to a function or formula.

- Optionally, click the cell that displays the error, click the button that appears , and then click
**Show Calculation Steps**if it appears. - Review the following possible causes and solutions.
Missing data, and #N/A or NA() has been entered in its place

Replace #N/A with new data.

**Note**You can enter**#N/A**in those cells where data is not yet available. Formulas that refer to those cells will then return #N/A instead of attempting to calculate a value.

Giving an inappropriate value for the lookup_value argument in the HLOOKUP, LOOKUP, MATCH, or VLOOKUP worksheet function

Make sure that the lookup_value argument (argument: The values that a function uses to perform operations or calculations. The type of argument a function uses is specific to the function. Common arguments that are used within functions include numbers, text, cell references, and names.) is the correct type of value — for example, a value or a cell reference, but not a range reference. Using the VLOOKUP, HLOOKUP, or MATCH worksheet function to locate a value in an unsorted table

By default, functions that look up information in tables must be sorted in ascending order. However, the VLOOKUP and HLOOKUP worksheet functions contain a range_lookup argument (argument: The values that a function uses to perform operations or calculations. The type of argument a function uses is specific to the function. Common arguments that are used within functions include numbers, text, cell references, and names.) that instructs the function to find an exact match even if the table is not sorted. To find an exact match, set the range_lookup argument to FALSE. The MATCH worksheet function contains a match_type argument that specifies the order the list must be sorted in to find a match. If the function cannot find a match, try changing the match_type argument. To find an exact match, set the match_type argument to 0.

Using an argument in an array formula that is not the same number of rows or columns as the range that contains the array formula

If the array formula (array formula: A formula that performs multiple calculations on one or more sets of values, and then returns either a single result or multiple results. Array formulas are enclosed between braces { } and are entered by pressing CTRL+SHIFT+ENTER.) has been entered into multiple cells, make sure that the ranges referenced by the formula have the same number of rows and columns, or enter the array formula into fewer cells. For example, if the array formula has been entered into a range 15 rows high (C1:C15) and the formula refers to a range 10 rows high (A1:A10), the range C11:C15 will display #N/A. To correct this error, enter the formula into a smaller range (for example, C1:C10), or change the range to which the formula refers to the same number of rows (for example, A1:A15).

Omitting one or more required arguments from a built-in or custom worksheet function

Enter all arguments (argument: The values that a function uses to perform operations or calculations. The type of argument a function uses is specific to the function. Common arguments that are used within functions include numbers, text, cell references, and names.) in the function.

Using a custom worksheet function that is not available

Make sure that the workbook that contains the worksheet function is open and the function is working properly.

Running a macro that enters a function that returns #N/A

Make sure that the arguments (argument: The values that a function uses to perform operations or calculations. The type of argument a function uses is specific to the function. Common arguments that are used within functions include numbers, text, cell references, and names.) in the function are correct and in the correct position.

Oct 31, 2008 | Computers & Internet

Use the **test** function.

Formula in cell A1 would be**=text(a2,"dddd").**

This would pick up the date from cell A2 and return the day of the week in cell A1.

Formula in cell A1 would be

This would pick up the date from cell A2 and return the day of the week in cell A1.

Jun 06, 2010 | Microsoft Excel for PC

- Start Microsoft Excel.
- Press ALT+F11 to start the Visual Basic Editor.
- On the
**Insert**menu, click**Module**. - Type the following code into the module sheet. Option Explicit 'Main Function Function SpellNumber(ByVal MyNumber) Dim Dollars, Cents, Temp Dim DecimalPlace, Count ReDim Place(9) As String Place(2) = " Thousand " Place(3) = " Million " Place(4) = " Billion " Place(5) = " Trillion " ' String representation of amount. MyNumber = Trim(Str(MyNumber)) ' Position of decimal place 0 if none. DecimalPlace = InStr(MyNumber, ".") ' Convert cents and set MyNumber to dollar amount. If DecimalPlace > 0 Then Cents = GetTens(Left(Mid(MyNumber, DecimalPlace + 1) & _ "00", 2)) MyNumber = Trim(Left(MyNumber, DecimalPlace - 1)) End If Count = 1 Do While MyNumber <> "" Temp = GetHundreds(Right(MyNumber, 3)) If Temp <> "" Then Dollars = Temp & Place(Count) & Dollars If Len(MyNumber) > 3 Then MyNumber = Left(MyNumber, Len(MyNumber) - 3) Else MyNumber = "" End If Count = Count + 1 Loop Select Case Dollars Case "" Dollars = "No Dollars" Case "One" Dollars = "One Dollar" Case Else Dollars = Dollars & " Dollars" End Select Select Case Cents Case "" Cents = " and No Cents" Case "One" Cents = " and One Cent" Case Else Cents = " and " & Cents & " Cents" End Select SpellNumber = Dollars & Cents End Function ' Converts a number from 100-999 into text Function GetHundreds(ByVal MyNumber) Dim Result As String If Val(MyNumber) = 0 Then Exit Function MyNumber = Right("000" & MyNumber, 3) ' Convert the hundreds place. If Mid(MyNumber, 1, 1) <> "0" Then Result = GetDigit(Mid(MyNumber, 1, 1)) & " Hundred " End If ' Convert the tens and ones place. If Mid(MyNumber, 2, 1) <> "0" Then Result = Result & GetTens(Mid(MyNumber, 2)) Else Result = Result & GetDigit(Mid(MyNumber, 3)) End If GetHundreds = Result End Function ' Converts a number from 10 to 99 into text. Function GetTens(TensText) Dim Result As String Result = "" ' Null out the temporary function value. If Val(Left(TensText, 1)) = 1 Then ' If value between 10-19... Select Case Val(TensText) Case 10: Result = "Ten" Case 11: Result = "Eleven" Case 12: Result = "Twelve" Case 13: Result = "Thirteen" Case 14: Result = "Fourteen" Case 15: Result = "Fifteen" Case 16: Result = "Sixteen" Case 17: Result = "Seventeen" Case 18: Result = "Eighteen" Case 19: Result = "Nineteen" Case Else End Select Else ' If value between 20-99... Select Case Val(Left(TensText, 1)) Case 2: Result = "Twenty " Case 3: Result = "Thirty " Case 4: Result = "Forty " Case 5: Result = "Fifty " Case 6: Result = "Sixty " Case 7: Result = "Seventy " Case 8: Result = "Eighty " Case 9: Result = "Ninety " Case Else End Select Result = Result & GetDigit _ (Right(TensText, 1)) ' Retrieve ones place. End If GetTens = Result End Function ' Converts a number from 1 to 9 into text. Function GetDigit(Digit) Select Case Val(Digit) Case 1: GetDigit = "One" Case 2: GetDigit = "Two" Case 3: GetDigit = "Three" Case 4: GetDigit = "Four" Case 5: GetDigit = "Five" Case 6: GetDigit = "Six" Case 7: GetDigit = "Seven" Case 8: GetDigit = "Eight" Case 9: GetDigit = "Nine" Case Else: GetDigit = "" End Select End Function

- Select the cell that you want.
- Click Paste Function on the Standard toolbar.
- Under Function category, click User Defined.
- Under Function name, click SpellNumber, and then click OK.
- Enter the number or cell reference that you want, and then click OK.

- Select the cell that you want.
- Click Insert Function on the Standard toolbar.
- Under Or select a category, click User Defined.
- In the Select a function list, click SpellNumber, and then click OK.
- Enter the number or cell reference that you want, and then click OK.

Apr 01, 2010 | Microsoft Windows XP Professional

please contact your service provider and ask for message center number and you need to enter that number in the message sending option then only your message will be sent

Sep 16, 2009 | LG KC550 Triband GSM 5MP Camera MP3 Phone...

Step1. Start Microsoft Excel and open the file you want to change.
Step2. Double-click on the cell where you want the total to appear.
Step3. Press the = key on the keyboard. This tells Excel that you are entering a formula into the cell.
Step4. Enter the formula, then press Enter. Follow the steps below for an example.
Step5. Enter an opening parenthesis character: (.
Step6. Enter a cell name. For example: =(E2.
Step7. Press the + key.
Step8. Enter another cell name and a closing parenthesis character: ). For example: =(E2+E3).
Step9. Enter a minus sign and a third cell name. For example: =(E2+E3)-E4.
Step10. Press the Enter key to accept the formula. The cell will display the sum of the first two cells minus the third cell.
$('.Article .Steps .Image').each(function(i,e){
e = $(e);
e.find('img').error(function(){
$(this).unbind();
e.remove();
});
});

Tips & Warnings

Tips & Warnings

- Formulas are just equations. Instead of adding or subtracting numbers you are adding and subtracting the contents of a cell.
- Excel includes a number of predefined functions to use as well. You can combine the predefined functions into your own formula. (See "How to Use Provided Excel Formulas.")

Dec 03, 2008 | Microsoft Office Professional 2007 Full...

Yes, its possible by designing a formula in excel.

Aug 03, 2008 | Microsoft Windows XP Professional

formula for the keys or short curt for excel

Jul 15, 2008 | Microsoft Excel for PC

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

Yes of course, if you have a little background of visual basic programming that's possible you can enhance your requirements.

Please see link http://www.techonthenet.com/excel/questions/cond_format1.php

Please see link http://www.techonthenet.com/excel/questions/cond_format1.php

Nov 29, 2007 | Microsoft Excel for PC

116 people viewed this question

Usually answered in minutes!

×