Question about Microsoft Excel for PC

2 Answers

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.

×

2 Answers

  • 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
  • 45 Answers

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

  • 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
  • 84 Answers

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

Hope this helps!

Posted on May 09, 2008

1 Suggested Answer

6ya6ya
  • 2 Answers

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

Hi,
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.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1 Answer

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.

Feb 24, 2013 | Office Equipment & Supplies

1 Answer

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.

Jun 13, 2011 | Casio FX991MS Scientific Calculator

1 Answer

Hi, i would like to know if you set your calculator to "float 3" so that it gives results in the form of x,xxx will the calculator when i calculate further using previous results use the float...


The display setting affects ONLY the display of the number. The calculations are always carried out with full precision. So in your example, further calculations are carried out using 3.141592654 no matter what the display says.

Apr 28, 2011 | Texas Instruments TI-15 Explorer...

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

Aug 04, 2010 | Casio FX-115ES Scientific Calculator

1 Answer

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

Apr 13, 2010 | Texas Instruments TI-89 Calculator

1 Answer

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
require activation; your phone will automatically switch to the “headset” mode if a headset
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.
You can also download ring tones online.
(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.
(3) Alert type
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

1 Answer

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


Start by creating the data lists.

CREATE THE X-LIST
  1. Press Home.
  2. Use navigation pad to Highlight [3: Lists and Spreadsheets]
  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.
  2. Use the Navigation pad to move cursor to the head of the B column.
  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.
a8d4376.jpg
Using Tab to move from one line to the next, configure the calculator as seen on the next screen.
25998ef.jpg
And the last line is at the bottom of the next screen capture
db280de.jpg

The statistical results will hence be displayed in the C[] column.
Use TAb to move focus to OK, and press ENTER.
Here they are.
bd6f8f9.jpg

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
8381923.jpg

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
ba8a1a4.jpg

Press ENTER to draw the function f1
fc19833.jpg

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.

Jan 28, 2010 | Texas Instruments TI-Nspire Graphic...

1 Answer

How do i enter pH on a TI 30 calculator


Hello,
This post answers two questions
  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
And please, show your appreciation by rating the solution.

Dec 07, 2009 | Texas Instruments TI-30XA Calculator

1 Answer

How to put cell phone to speakerphone mode


Manual:
http://www.cellphones.ca/upload/manuals/samsung-sph-m300-manual.pdf

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
through the Options menu:
 (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
this menu.
 (5) Contacts accesses the Contacts menu.
 (6) 3-Way Call allows you to talk to two different people at
the same time. (For more information, see “Making a
Three-Way Call” on page 189.)
 (7) Messaging accesses the Messaging menu options.
 (8) Voice Memo allows you to record incoming audio from
your conversation. (For more information, see “Managing
Voice Memos” on page 135.)
 (9) Tools accesses the Tools menu options.

Manual:

Mar 21, 2009 | Samsung SPH-M300 Cellular Phone

2 Answers

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

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

127 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2644 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18381 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

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

Answer questions

Manuals & User Guides

Loading...