Question about Microsoft Excel 2000 Step by Step (1572319747) for PC

Ad

What are the "cases"? Your example "more then 8 or less then 9 use 400" implies that there is a decimal part e.g. 8.5 . Is that right?

You dont need to test in both directions

e.g. assuming you name the cell with your number in it "cases"

=if(cases<9,400,if(cases<10,410,if(cases<11,420,430)))

Need more information on what the numbers are to help further

Posted on Nov 07, 2008

Ad

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.

Good luck!

Posted on Jan 02, 2017

Ad

I will not do your homework for you Hun!! Look up your math notes or look on-line for the formula to use!!!

Happy figuring!!

Happy figuring!!

Apr 01, 2017 | The Computers & Internet

upgrade your hard drive

Jan 13, 2011 | Nitro S-10000 Storm Series Ax Aluminum...

Stream

Vol %

Units/Hr

Total Volume

Hrs Reqd

Staff Reqd

Pick

1

100

=(D3*B2)/B3

=D2/C2

=E2/10

Pack A

0.75

150

7500

=D3/C3

=E3/10

Pack B

0.25

25

=D2-D3

=D4/C4

=E4/10

Paste this in an Excel Spread sheet. After pasting it press CTRL+~.

Vol %

Units/Hr

Total Volume

Hrs Reqd

Staff Reqd

Pick

1

100

=(D3*B2)/B3

=D2/C2

=E2/10

Pack A

0.75

150

7500

=D3/C3

=E3/10

Pack B

0.25

25

=D2-D3

=D4/C4

=E4/10

Paste this in an Excel Spread sheet. After pasting it press CTRL+~.

Sep 01, 2010 | Computers & Internet

Here is how you could do the formula with two one column having the hours of each day in it and the overtime being in another cell:

Example:

Column A Column B

8

8

8

2

8

8

0

Total 40 OverTime 2

Formula in this cell where 40 is at:

=IF(SUM(A1:A7)>40,40,SUM(A1:A7))

Formula in cell where 2 is at:

=IF(A8>40,0,SUM(A1:A7)-A8)

Let me know if this helps.

Example:

Column A Column B

8

8

8

2

8

8

0

Total 40 OverTime 2

Formula in this cell where 40 is at:

=IF(SUM(A1:A7)>40,40,SUM(A1:A7))

Formula in cell where 2 is at:

=IF(A8>40,0,SUM(A1:A7)-A8)

Let me know if this helps.

Jan 01, 2010 | Microsoft Excel 2007 Home and Student...

It's simple here some logs:

log x base y = log x / log y

log (x*y) = log x + log y

log (x/y) = log x - log y

you just need to know that the default base of log in calculators is 10, so log x mean

log x base 10 = log x / log 10,

so write log x / log y for log x base y example:

log 8 base 2 = log 8 / log 2 that is how you write it on calculator, hope it was helpful

log x base y = log x / log y

log (x*y) = log x + log y

log (x/y) = log x - log y

you just need to know that the default base of log in calculators is 10, so log x mean

log x base 10 = log x / log 10,

so write log x / log y for log x base y example:

log 8 base 2 = log 8 / log 2 that is how you write it on calculator, hope it was helpful

Jul 01, 2009 | Texas Instruments TI-83 Plus Calculator

=10000*(1+0.96)^12

=10000*(1+0.10)^18

=10000*(1+0.10)^24

=10000*(1+0.10)^18

=10000*(1+0.10)^24

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

Hello,

The formula should go like this:

=IF(C11>40,(C11-40)*D11,0)

This one will give you the result of (ONLY overtime hours)*(hourly wage), and if there are no overtime hours the result is 0.

Now, if you need to multiply that result with say 1,5 or whatever - insert the number you need like this:

=IF(C11>40,(C11-40)*D11*1.5,0)

If you need more help, please ask.

The formula should go like this:

=IF(C11>40,(C11-40)*D11,0)

This one will give you the result of (ONLY overtime hours)*(hourly wage), and if there are no overtime hours the result is 0.

Now, if you need to multiply that result with say 1,5 or whatever - insert the number you need like this:

=IF(C11>40,(C11-40)*D11*1.5,0)

If you need more help, please ask.

Sep 14, 2008 | Computers & Internet

go to the field with the number of day formula and modify the formula just add to it this *8. The result will be in hrs.

Assuming a holiday uses 8 hrs of pay. It sounds like everyone starts with 25 holiday X 8 hrs or 200 total hours,

Assuming a holiday uses 8 hrs of pay. It sounds like everyone starts with 25 holiday X 8 hrs or 200 total hours,

Jun 18, 2008 | Computers & Internet

Release the handle and lay the machine handle

back to access the Tank.

**
2**. Remove the Tank from the base of the machine by

lifting the Tank carry Handle.

**
3. **Carry like a bucket to the sink. Rotate the Handle

forward to unlatch the lid. Lift off and set the lid aside.

**
4. **Fill up the Bladder with clean hot tap water.

**
*Do not boil or microwave water as it can**

destroy the Bladder.

5.Replace the top of the Tank by matching the lid

and tank edges. Handle must be in the forward

position in order to replace lid. Rotate the handle

to the carrying position to latch the lid.

**
Note: Remember to secure the lid and test to**

make sure it is secure before picking up the Tank.

6.Place tank into machine base, seating firmly in place.

Rotate tank handle back into latched position. Bring

machine handle back into upright position.

**
**

1.Lift the formula Tank up and out of the machine base.

**
2. **To fill the Formula Tank, first unscrew the Cap

and Insert. Always use genuine BISSELL formulas

to maximize cleaning and for the safety of your

machine. Fill formula up to the line and replace the

Cap and Insert. Place Formula Tank back into the

base of machine, making sure it is seated securely.

**
Note: If bottle leaks, check for proper positioning**

of red gromment and straw.

back to access the Tank.

lifting the Tank carry Handle.

forward to unlatch the lid. Lift off and set the lid aside.

destroy the Bladder.

5.

and tank edges. Handle must be in the forward

position in order to replace lid. Rotate the handle

to the carrying position to latch the lid.

make sure it is secure before picking up the Tank.

6.

Rotate tank handle back into latched position. Bring

machine handle back into upright position.

1.

and Insert. Always use genuine BISSELL formulas

to maximize cleaning and for the safety of your

machine. Fill formula up to the line and replace the

Cap and Insert. Place Formula Tank back into the

base of machine, making sure it is seated securely.

of red gromment and straw.

Apr 29, 2008 | Bissell 1699 ProHeat Clear View Upright...

You need to calculate the totals for each category, by entering a formula such as: = C2 * 12.00 where C2 is the location of the hours and your hourly rate is $12.00. You can fill in the C2 part in each formula by clicking on the cell you want the total in, then typing the equal sign, then selecting the cell that you want to get the hours from, then enter the multiply operator (asterisk *) which is a Shift + 8 on your keyboard or the * over the 9 key on the numerical keypad. Repeat for each entry, using the correct cell and the correct amount (in this example it might be $18.00 for overtime hours). Then you just total all the formulas by using Autosum, which you invoke by using the Ʃ symbol, which will give you a sum of the cells you select. If this isn't clear enough, please let us know.

Hope this will FixYa!!!

Hope this will FixYa!!!

Mar 03, 2008 | Computers & Internet

Apr 07, 2010 | Microsoft Excel 2000 Step by Step...

139 people viewed this question

Usually answered in minutes!

×