Question about Microsoft Excel for PC

1 Answer

How do i multiply a value by a minimum amount

1,2,3 or 4 x 60 = 240
5 or more, normal sum

Posted by on

1 Answer

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

    Hot-Shot:

    An expert who has answered 20 questions.

  • Expert
  • 67 Answers

I you have a row with 6 values you can get the minimum number from that area. Example:
A1: 6
A2: 8
A3: 3
A4: 9
A5: 2
A6: 7

in B2 we want to pick the smallest value in that group and multiply it with 60. This is what you type in B2

=min(A1:A6)*60

Yeah :)
that's all.... Good Luck :)



Posted on Feb 24, 2009

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

Column 75" tall, 16" wide and 16" deep. How many sq feet of stone to cover the column and top?


you have a rectangle of of 75 X by16 and you have 4 of those rectangles so multiply 75 X 16 and then multiply the sum by 4
then you have the ends which are squares of 16 X 16 so multiply 16 X 16 Nd then multiply the sum by 2
then add the 2 sums together to get the total square inches of the surface of the object
now one square inch =.00694 square feet so multiply the total sum by .00694 to get the area in square feet
grade 4 maths really

Jan 04, 2017 | Office Equipment & Supplies

1 Answer

I need help creating a nested if/and statement in Excel using the following parameters:


See if this works


=IF(J28<17,0,IF(J28<=25, J27*0.12, IF(J28<=30, J27*0.15, IF(J28<=35, J27*0.2, IF(J28<=40, J27*0.25, J27*0.3)))))


You may have to adjust for your boundary conditions. For example, if the value is 25, do you want to multiply by 12% or 15%?

Good luck,

Paul

Nov 28, 2016 | Office Equipment & Supplies

2 Answers

How do i calculate 1.734 = (1+r)5 and get 1.1164. I keep getting an answer of 6.58


you have to know the value of r and then you follow the maths laws of multiplication.division , addition and subtraction in that order
so 1.734 = the sum of 1+r, multiplied by 5

Oct 14, 2015 | Office Equipment & Supplies

1 Answer

How many gallons in an 88" x 15" x 9" trough?


try this :

Instructions
  1. Measure the rectangle length, width and height. For example, 8 inches long, 6 inches wide, 10 inches high.
  2. Multiply the length by the height, then double the product. With this example, 8 inches multiplied by 10 inches results in 80 square inches, which multiplied by 2 equals 160 square inches.
  3. Multiply the width by the length, then double the product. With this example, 6 inches multiplied by 8 inches equals 48 square inches, which multiplied by 2 equals 96 square inches.
  4. Multiply the height by the width, then double the product. With this example, 10 inches multiplied by 6 inches results in 60 square inches, which multiplied by 2 equals 120 square inches.
  5. Sum the amounts from Steps 1 through 3 to find the rectangle surface area. So adding 160, 96 and 120 square inches results in 376 square inches.


1 Us gallon is 231 cubic inches

Sep 05, 2015 | Garden

1 Answer

Sabrina lunch came to $12.50. she want to leave an 18% tip. how much should she leave?


To find 18% of the bill, just multiply the $12.50 by 0.18 which gives the following:

$12.50 X 0.18 = $2.25

Therefore the 18% tip should be $2.25

Therefore the total amount to leave (bill + tip) is $12.50 + $2.50 = $15.00



An easier way to figure this total out is to multiply the bill amount by 1.18 which gives you the total sum of the bill plus the 18% tip.

Good luck, i hope this helps.

Joe.

Oct 25, 2011 | Texas Instruments TI-84 Plus Calculator

2 Answers

What are the formulas in grading the grades uisng microsoft excel


Formulas are used to specify calculations based on values in designated cells. Excel supports basic calculations as well as statistical, trigonometric and other specialized functions.

Formulas used in Excel must follow a certain syntax.

  1. All formulas begin with an equals sign (=).
  2. Some formulas use operands such as +,-, *,/ for addition, subtraction, multiplication or division.
    For example, the formula =A1+A2+A3 would add the contents of cells A1, A2 and A3.
  3. Other formulas refer to different functions such as SUM, AVERAGE and others.
    For example, the formula =SUM(A1:A3) would add the contents for the range A1 through A3.
  4. Formulas can be combined with operands.
    For example, the formula =10*SUM(A1:A3) would add the contents cells A1 through A3 and multiply them by 10.
  5. Functions can be nested within each other.
    For example, the formula =SQRT(10*SUM(A1:A3)) would take the square root of ten times the sum of cells A1 through A3. When functions are nested, it is important that the number of left parentheses match the number of right parentheses.

Aug 19, 2011 | Microsoft EXCEL 2004 for Mac

1 Answer

Estimate the bond energy' S-F' in SF6.the standard enthalpy of formation of SF6(gas),S(g),F(g) are-1100kj/mole,275kj/mole,80kj/mole respectively


What is the S-F bond energy in SF6 given DHfo for each of the reaction components?

For this problem you must first calculate the change in enthalpy (heat transfer, delta H under standard conditions) for the conversion, S(g) + 6F(g) => SF6(g) OR for the reverse reaction, it really doesn't matter, because the numerical value will be the same, regardless. Once you calculate the heat transferred, you will be able to say that the amount of heat transferred was the amount of potential energy trapped in all of the S-F bonds, all six of them in the molecule. So, to obtain the answer asked for (the energy content on one S-F bond), all you will have to do is divide by 6.

The above is a logical approach, because all six of the S-F bonds are identical. This is so, because, according to VSEPR theory (look it up for more background on that, if you are interested), you can predict that its molecular geometry is "octahedral" with the central sulfur atom having "sp3d2 hybridization."

Here is how you set up the problem:

First write the balanced chemical equation with the given heats of formation (in kJ) written under each of the reaction components:
S(g) + 6F(g) => SF6(g)
275 6(80.) -1100.

Note: I am assuming that each of the above quanties is good (i.e., known) to at least the unit's place; that is, + or - 1 kJ. This reasonable assumption allows me to unambiguously indicate the number of sig figs in each quantity - an important consideration for proper rounding off of the final answer.

Recall that the sum of the product values minus the sum of the reactant values, each component multiplied by its corresponding coefficient will give the net enthalpy ("reaction enthalpy") of the reaction as written. In this case, there being only one product, the reaction enthalpy is:
-1100 - (480 + 275) = - 1855 kJ. From this, we can see that as S and six Fs are combined, 1,855 kJ of heat are released into the surroundings (that is, an exothermic reaction). The amount of heat released informs you of the combined bond energy of ALL six S-F bonds.

A good rule to remember: As bonds are formed, energy is always released (an exothermic process). As bonds are broken (as in the reverse reaction), the same amount of energy is being absorbed (an endothermic process).

Therefore, in conclusion, one S-F bond has a bond energy of 309.17, which is more properly rounded off to 309 kJ.

Recall that the rule for rounding off when adding or subtracting is to make sure that the final answer has the same precision as the values used to calculate it. Since each given value was good only only to the last unit

Nov 22, 2010 | MPS Multimedia QuickStudy Chemistry for PC

1 Answer

Multiply a value by a minimum amount


You need a cell to put these numbers first. Lets say A1 is your reference cell where the numbers are going to be input. B1 is the cell that you are going to see the calculation. Type the following formula in B1

=IF(A1<4,4*60,A1*60)

after doing this you can put any number in A1 and it will give you the calculation in B1 as the way you wanted.

Feb 24, 2009 | Microsoft Excel for PC

1 Answer

Excel help


Maybe this is what you need:
=IF(A1="toilet",(B1*2),(IF(A1="bread",(B1*3),(IF(A1="star",(B1*4))))))
this is called "nested".
You can put nested if function maximum 7. (for more than 7, we should make another "trick")
if you put toilet in A1 then come the value B1*2
if you put bread in A1 then come the value B1*3
if you put star in A1 then come the value B1*4
Note: SUM(F16*0.3) is wrong. should be only (F16*0.3) or if you want to do sum --> SUM(F16:F20)

Apr 01, 2008 | Microsoft Office Professional 2007 Full...

3 Answers

Excel Formula


columns total in additin cells of rows equal are total

Oct 24, 2007 | Oracle 10g Database Standard (ODBSEONUPP0)

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

192 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2642 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

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