Question about Microsoft Excel for PC

# Display calculation result in a previous cell

This spreadsheet will allow each team member to enter a number for the whisper tone used on an incoming call and then a letter for the real purpose of the call. What I want is a formula at the bottom. let's say in row 80 to total matches at the bottom. for example IF cell e6 = 5 and cell F6 = m, then display a 1 otherwise display a zero.I got that far. Now I have two problems. I want the formula to test every row for matches. Each row is equal to one call and there could be as many as seventy-five calls. Then at the bottom where the test formula is, I want the count to change. If I have to use the above formula for each row, that is fine. I think I can just hide the contents of the cell and lock it so they cannot mess it up. What I do want is after the first row the next formula would be IF cell E7 = 5 and cell F7 = m, then go back to total that is in Row 80 and change the 1 to a 2 if they match or leave it the number that is already there if they did not match. Can you help?

Posted by on

• DANISH2K3 Nov 06, 2008

i WANT TO KNOW NOT EQAUL TOO FORMULA.

×

### Danilo Mante

• Level 1:

An expert who has achieved level 1.

Hot-Shot:

An expert who has answered 20 questions.

Corporal:

An expert that has over 10 points.

Mayor:

An expert whose answer got voted for 2 times.

• Contributor

From rows 1 to 75, create a dummy column with the formula e&"/"&f.
starting row 80 and using columns e and f, fill out all possible entry combinations for columns e and f.

then, for each possible combination, use the formula countif(dummy column range,e&" "&f)

note that the ("/") is put up to separate values of e and f.

Posted on Nov 18, 2008

### Rick Johnson

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

Scholar:

An expert who has written 20 answers of more than 400 characters.

• Expert

Look into the =SUMIF function, it sounds like this may be what you are looking for.

Hope this helps!

Posted on May 09, 2008

×

my-video-file.mp4

× ## Related Questions:

### How to use the statistics

Scientific calculator
The most basic scientific calculator can do simple 1-variable statistics. Usually you put the calculator in STATistics Mode, then CLEAR all statistics data that may already be stored.
You enter a data value by typing in the number then pressing a key marked DATA. The calculator may display the number 1 for the 1st point. Then as you enter more values, the display shows number that increase by 1.
Once you finish entering data values, you may have to press AC button to exit the data entry phase.
Then you look for the second function (2nd 2ndF, or SHIFT) of some keys. The one marked with an x with a bar on top give the average, the one with marked n give the number of data entered. You may have other keys with the Greek Capital Letter SIGMA. They give various results such as sum of squares, etc. Check your manual for more details.
Newer calculators allow you to use the frequency if there are repeated values. I cannot say more because I do n ot have the make and model of the calculator.

### How can I find :11^27mod 29 using my CASIO fx-99IES

11^27 = 13,109,994,191,499,930,367,061,460,371 which is 29 digits long.

You can get this result from the Windows calculator (scientific view) by entering 11 and then pressing x^y 27 = . Then use Mod 29 = to get the result, which is 8.

Unfortunately the Casio fx-991ms (as with most other calculators) doesn't have nearly enough digits to cope with this type of calculation. You therefore need to split the calculation down into more manageable chunks, as follows, which works on most calculators:

First calculate 11^3 = 1,331 and work out Mod 29, which is 1,331 - 45×29 = 26.
Then calculate 26^3 = 17,576 and work out Mod 29, which is 17,576 - 606×29 = 2.
Finally calculate 2^3 = 8. Since this is less than 29, it is also the final answer as confirmed above.

This method can be used with any power number that can be factorised into numbers that don't cause the available digits of the display to overflow. In this case 27 = 3×3×3 so each step involves cubing the previous answer.

### Multiplication with 2 digits

When using calculators the number of digits in the numbers being multiplied is not an issue. Just enter the first number press the multiplication key (X) and then enter the second number. Press ENTER or = or EXE (depending on calculator) and you get your result.
If the calculator does not have enough places to display the result, the calculator will use scientific notation.

The largest number that most calculators will be able to handle is 9.9999999999999X10^99. The cut off value is 1.x10^100.

### How can i get logarithms on the calculator

For natural logarithms Press [2nd][X], enter a positive number, close the right parenthesis and press [ENTER]. If the number is decimal the result is displayed as a number. If the number is integer, put a decimal mark at its end to have the result displayed as decimal.

For decimal logarithms use the ALPHA keyboard to enter the log( command, complete the argument and press ENTER

If you want to calculate log in base a of number b type log(b,a).

### How do i put phone on silent

User profiles
This is used to set up the different ways of incoming call prompts in various situations. Use
the up/down key to choose this option and click the left functional key to enter. There are
many modes of setting available and the default setting is the general mode.
To switch to a new user profile, use the direction key to select the target mode and click
“OK” to enter. Then select “activate” and click “OK” to confirm. Your phone will give an
“activated” prompt, indicating that the user profile is active. The “headset” mode does not
is connected to your phone, and back to the previous mode when unplugged.
You can also customize each user profile setting for your preference, the following
operations are available:
(1) Ring tone settings:
Incoming calls: Enter “user profile”, select “personal setting”, and set up the ring tone.
Power on: set up the music for power on.
Power off: set up the music for power off.
Message: set up the message ring tone when a new message arrives.
(2) Volume
This allows you to set up the volume for ring tones and keypad tones. There are 7 grades
available. Enter this function and use the up/down key for testing and adjusting.
This is used to set up the alert type for incoming calls. Please select the suitable alert
types in different situations.

Mar 25, 2010 • Cell Phones

### How do i perform linear regressions on TI-Nspire Individual Handheld

Start by creating the data lists.

CREATE THE X-LIST
1. Press Home.
3. Press Enter
4. A list opens with cursor in Cell A1.
5. Use UpArrow to move the cursor to the header of the list and give it a name, say X.
6. Press Enter. Cursor moves to Cell A1
7. Enter an X-value in each cell and press ENTER to move to next cell:
8. Type 1, and press ENTER. Say Yes to overwrite message by pressing OK.
9. Enter 2,3,4,5,6,7,8,9,10 (just a bogus sample).
CREATE THE Y-LIST
1. After typing 10 in cell A10, press ENTER to validate.
3. Give it a name , say Y.
4. Press ENTER, Cursor moves to cell B1.
5. As for X-list, enter the Y values. Here is a sample (-2, -1, 0, 1,2,3,4,5,6,7). After you type value in B1, accept the overwrite message by pressing OK. Type the other values.
6. Make sure that the X-List and Y-List have the same number of elements, otherwise you will have a dimension mismatch error.
DOING A REGRESSION
1. While the lidt is still displyed, prress the Menu key
2. Highlight [4:Statistics]
3. Use Right Arrow to unfold submenu list and select [1:Stat Calculations]
4. Use right Arrow to unfold the submenu list and
5. Select [3:Linear regression (mx+b)] or [4:linear regression (ax+b)]
That is what you see. Using Tab to move from one line to the next, configure the calculator as seen on the next screen. And the last line is at the bottom of the next screen capture The statistical results will hence be displayed in the C[] column.
Use TAb to move focus to OK, and press ENTER.
Here they are. You can recognize each statistical results, RegEq is y=mx+b. You also have m, b, r^2, and r. The residuals appear on the next row. By highlighting the cell with the {0.,0...0} you can display the hidden values Here you have all you asked for. But you can go further by drawing the curve.

The regression equation is stored in function f1, so you have to draw the f1 function. .

DRAWING THE REGRESSION CURVE

Press the HOME button
Highlight and select [2:Graphs and Geometry]
At the bottom of the screen there is a command line with f2(x)=
Use the UpArrow to display the f1(x)= equation Press ENTER to draw the function f1 I think I have to stop here. There is enough material to get you started.
I left for you the part where you draw the data points. read the user manual.

### How do i enter pH on a TI 30 calculator

Hello,
1. How to obtain the concentration knowing the pH?
2. How to obtain the pH knowing the concentration
If you are not interested in the theory, jump to the examples at the end of the post.

As you well know the pH is the negative of the log in base 10 of the H+/H3O+ ion concentration. If we use [H+] to represent that concentration, then pH=-log[H+].
To obtain the [H+] you need to calculate the antilog. You write the definition in the form log[H+] =-pH and then calculate 10 to the power of each member. The equality remains valid as both members are treated similarly. Thus
10^( log[H+] ) = 10^(-pH)
Since raising 10 to a power is the inverse function of taking the log in base 10, 10^(log(x))=log(10^(x)) = x (they are inverse of one another), you are left with

[H+]=10^(-pH)

Your calculator has a function [10 to x] accessed by pressing the [2nd] function key. To use it you must enter the negative value of the pH, press the [2nd] function key then the [10 to x], then the = key to get the result (concentration)
Examples

1. Let the pH=5.5, what is the H+ concentration?

With [(-)] being the change sign key, then
[H+]:[ (-) ] 5.5 [2nd][10 to x] [=]
The result is 0.000003162 or 3.16 x 10^(-6)

Calculating the pH

Shortcut:
For all H+/H3O+ concentrations of the form 1.*10^(a) where a is an integer number between 0 and -14, the pH is the negative value of the exponent.
Concentration =10^(-3), pH=3
Concentration=10^(-11), pH=11

For other concentrations such as 3.567*10^(-8), one cannot use the shortcut above, but have to calculate the log of the concentration

[H+/H3O+] = 3.567*10^(-8)
pH= - log(3.567*10^(-8))
This is keyed in as follows (to minimize the number of parentheses)

8 (-) [2nd][10 to x] [*] 3.567 [LOG] [=] (-)
Here you have two (-) change sign, the first is entered after the exponent of 10, the other at the end of the calculation to take the negative of the displayed result. You may notice that it is entered in the reverse order of the defining relation - log(3.567*10^(-8)).
To verify your calculation, the result is 7.447696891 or just 7.45
If you have a problem with the first (-) try entering it before you type in 8.

Hope it helps and thank you for using FixYa

### How do you enter the equation 4(5x+3)=2(7x+6) in the calculator?

http://support.casio.com/pdf/004/fx-115ES_991ES_Eng.pdf
Refer to page 12 of the manual under Inputting expressions and values. It is pretty straight forward if you need further assistance please let me know.
Thank you,
Lee

### How to put cell phone to speakerphone mode

Manual:

From Page 39 of the manual:

Selecting Options (right softkey) during a call displays a list of
features you may use during the course of a call. To select an
option, press the corresponding keypad number or highlight
the option and press . The following options are available
 (1) Key Mute/Unmute allows you to mute the microphone
on your phone so the caller is unable to hear any sound.
 (2) Turn Speaker On enables the speakerphone feature.
 (3) Set Whisper increases the microphone to its maximum
level. During a call turn on Set Whisper when speaking
softly or when the caller cannot hear your voice clearly.
This mode is useful in meetings or public places.
 (4) Call History checks your call log for Outgoing, Incoming,
Missed, and Recent calls. You can also erase the logs from
 (5) Contacts accesses the Contacts menu.
 (6) 3-Way Call allows you to talk to two different people at
Three-Way Call” on page 189.)
 (7) Messaging accesses the Messaging menu options.
 (8) Voice Memo allows you to record incoming audio from
Voice Memos” on page 135.)
 (9) Tools accesses the Tools menu options.

Manual:

### Can I get the asswer for the below questions

A book shop maintains the inventory of books that are being sold at the shop. The list has details like author, title, price, publisher and stock position. Whenever a customer wants a book, the sales person inputs the title and author and the system searches the list and displays a suitable message if it is not available. If it is available, the system displays the book details and requests for the number of copies required. If the copies are available, the total cost of the copies requested is displayed, otherwise the message ‘copies not in stock’ is displayed.
Design a system using a class called BOOKS with suitable member functions and constructors. Use new operator in constructors to allocate required memory space.
Nov 16, 2008 • Computers & Internet

141 views

Level 3 Expert