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?

Ad

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

Ad

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

Hope this helps!

Posted on May 09, 2008

Ad

Hi,

a 6ya Technician 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 repair professionals here in the US.

click here to Talk to a Technician (only for users in the US for now) and get all the help you need.

Goodluck!

Posted on Jan 02, 2017

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.

The most basic scientific calculator can do simple 1-variable statistics. Usually you put the calculator in

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.

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

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.

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

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

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.

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

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

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

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.

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

Start by creating the data lists.

CREATE THE X-LIST

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.

CREATE THE X-LIST

- Press Home.
- Use navigation pad to Highlight [3: Lists and Spreadsheets]
- Press Enter
- A list opens with cursor in Cell A1.
- Use UpArrow to move the cursor to the header of the list and give it a name, say X.
- Press Enter. Cursor moves to Cell A1
- Enter an X-value in each cell and press ENTER to move to next cell:
- Type 1, and press ENTER. Say Yes to overwrite message by pressing OK.
- Enter 2,3,4,5,6,7,8,9,10 (just a bogus sample).

- After typing 10 in cell A10, press ENTER to validate.
- Use the Navigation pad to move cursor to the head of the B column.
- Give it a name , say Y.
- Press ENTER, Cursor moves to cell B1.
- 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.
- Make sure that the X-List and Y-List have the same number of elements, otherwise you will have a dimension mismatch error.

- While the lidt is still displyed, prress the Menu key
- Highlight [4:Statistics]
- Use Right Arrow to unfold submenu list and select [1:Stat Calculations]
- Use right Arrow to unfold the submenu list and
- Select [3:Linear regression (mx+b)] or [4:linear regression (ax+b)]

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.

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

Hello,

This post answers two questions

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)

**Example**s

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

This post answers two questions

- How to obtain the concentration knowing the pH?
- How to obtain the pH knowing the concentration

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

To obtain the [H+] you need to calculate the antilog. You write the definition in the form

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

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

With [(-)] being the change sign key, then

[H+]:

Calculating the pH

For all H+/H3O+ concentrations of the form

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)

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.

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.

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

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:

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

From Page 39 of the manual:

Selecting

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:

on your phone so the caller is unable to hear any sound.

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.

Missed, and Recent calls. You can also erase the logs from

this menu.

the same time. (For more information, see “Making a

Three-Way Call” on page 189.)

your conversation. (For more information, see “Managing

Voice Memos” on page 135.)

Manual:

Mar 21, 2009 | Samsung SPH-M300 Cellular Phone

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.

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

Jan 28, 2016 | Microsoft Excel for PC

Dec 12, 2013 | Microsoft Excel for PC

Jul 23, 2013 | Microsoft Excel for PC

130 people viewed this question

Usually answered in minutes!

i WANT TO KNOW NOT EQAUL TOO FORMULA.

×