Project I am working on has the following:

Base Rate, Opt Yr 1, Opt Yr 2, Opt Yr 3, Opt Yr 4.

I need each Opt Yr to calculate Base Rate + 5%, However, I have 40 rows to do this for. Can I create a formula outside the cells I am using that will automatically calculate each time I put a base rate in a cell instead of having to create a formula for each and every cell in every row? I know it is possible but I cannot remember how to do it and I was stumped when creating the formula. I believe I am missing something. Please help, project due soon!

Yes you can create the formula outside the cell or you can create it one time and copy it down to the other cells. That way it will populate once it is used.

The formula should be Base Rate * .05 to get the result then add the result back to the base rate.

Posted on Dec 18, 2008

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

school work you should solve by yourself... not by fixya...

you have following data:

v = volume = 320liters

d = distance = 2383km (kilometers is a single word...)

there is several formula to solve this mathematical problem, if you want how many liters per 100km formula is as follows:

(v/d) x 100 = 100km/ltr just substitute your data

if you hear then that vehicle is using 7.5ltr/100km that was the formula. unfortunately - you need to calculate your own data, this was just an example...

another variation is distance per liter, there is formula:

d/v = distance (kilometers) per liter

if you hear that car is driving 11km/ltr - that is again, and example, you need to calculate your own data...

enjoy! and vote...

you have following data:

v = volume = 320liters

d = distance = 2383km (kilometers is a single word...)

there is several formula to solve this mathematical problem, if you want how many liters per 100km formula is as follows:

(v/d) x 100 = 100km/ltr just substitute your data

if you hear then that vehicle is using 7.5ltr/100km that was the formula. unfortunately - you need to calculate your own data, this was just an example...

another variation is distance per liter, there is formula:

d/v = distance (kilometers) per liter

if you hear that car is driving 11km/ltr - that is again, and example, you need to calculate your own data...

enjoy! and vote...

Feb 10, 2015 | Haier DWL3525DDBB 24 inch Built-in Tall...

Here is to get you started. To increase the size of the image do a CTRL Plus (+) in your browser.

You need to calculate the slant height of the pyramid for the formula of the lateral area. You should find a value of** (1/2)*SQRT(203) **or about 7.1239 cm

You need to calculate the altitude (height) of the pyramid from the apex (summit) to the center of the base triangle (center of inscribed circle, barycenter, orthocenter). The hypotenuse of such triangle is the slant height. One leg is the altitude (to be found),**the measure of the second leg is (1/3) the altitude** **of the equilateral triangle** that forms the base. You should find (1/3) m MH= (1/3)* **(11/2)*SQRT(3)**

1. Calculate the area of the base (use a formula for the equilateral triangle or the general formula for a triangle: you have its height MH ).

2. Lateral area = 3 times the area of triangle Triangle ECD (in yellow above).

3. Total area = area of base + lateral area.

4. Volume= (1/3)(Area of base)* (height of pyramid)

If you can see the details on the screen capture below, fine, Press CTRL + in your browser to increase the size.

You need to calculate the slant height of the pyramid for the formula of the lateral area. You should find a value of

You need to calculate the altitude (height) of the pyramid from the apex (summit) to the center of the base triangle (center of inscribed circle, barycenter, orthocenter). The hypotenuse of such triangle is the slant height. One leg is the altitude (to be found),

1. Calculate the area of the base (use a formula for the equilateral triangle or the general formula for a triangle: you have its height MH ).

2. Lateral area = 3 times the area of triangle Triangle ECD (in yellow above).

3. Total area = area of base + lateral area.

4. Volume= (1/3)(Area of base)* (height of pyramid)

If you can see the details on the screen capture below, fine, Press CTRL + in your browser to increase the size.

Mar 29, 2014 | Office Equipment & Supplies

All triangles have three sides.

There are two main formulas that do not call on trigonometric ratios.

**The classic one**:

*Heron's Formula *if you have the length of the three sides. Let those measures be **a, b,** and** c**.

There are two main formulas that do not call on trigonometric ratios.

- 1. You need the length of a base and it corresponding height (the length of the segment perpendicular to that base and passing through the vertex (summit) opposite to that base.
**Area=(1/2) * (measure of the base)*(measure of the height).**The base and height must be expressed in the same unit.

- Calculate the semi-perimeter p with
**p=(1/2)(a+b+c)** - Area=Square root of
**(p*(p-a)*(p-b)*(p-c))** **a, b, and c must be expressed in the same unit.**

May 21, 2011 | Casio FX82ES Scientific Calculator

Work with the simple formula:
Interest = Initial * rate * time

To find the total amount, add the Initial plus the Interest, then subtract what has been paid. This will change the amount of money that will be accruing interest, though, so if there is a payment schedule you will need to repeat this calculation to get an exact number.

Find more information on wikipedia: http://en.wikipedia.org/wiki/Interest#Simple_interest

To find the total amount, add the Initial plus the Interest, then subtract what has been paid. This will change the amount of money that will be accruing interest, though, so if there is a payment schedule you will need to repeat this calculation to get an exact number.

Find more information on wikipedia: http://en.wikipedia.org/wiki/Interest#Simple_interest

Mar 07, 2011 | Texas Instruments BA-II Plus Calculator

Pressing 2 0 0 LN = will give you the natural logarithm of 200. If you need the common (base 10) logarithm, divide the result by the log of 10.

( 2 0 0 LN ) / ( 1 0 LN ) =

will give you the common log of 200.

( 2 0 0 LN ) / ( 1 0 LN ) =

will give you the common log of 200.

Jan 05, 2011 | Texas Instruments BA-II Plus Calculator

rind the exchange rate, perhaps at a site such as:

http://www.x-rates.com/

so, for example, 1 euro is apparently worth 1.4765 US$ at the moment.

if you have 13.82 US$ divide by 1.4765 to get 9.36 euro.

if you had 32.00 euro then multiply by 1.4765 to come up with 47.25 US$

http://www.x-rates.com/

so, for example, 1 euro is apparently worth 1.4765 US$ at the moment.

if you have 13.82 US$ divide by 1.4765 to get 9.36 euro.

if you had 32.00 euro then multiply by 1.4765 to come up with 47.25 US$

Oct 13, 2009 | Casio Office Equipment & Supplies

you need the change of base formula:

log base b of m is ln m / ln b

So- to find log base 2 of 8, simply find ln8/ln2

(from Wikipedia - the proof also follows if you want to go look it up)

While there are several useful identities, the most important for calculator use lets one find logarithms with bases other than those built into the calculator (usually log*e* and log10). To find a logarithm with base *b*, using any other base *k*:

log base b of m is ln m / ln b

So- to find log base 2 of 8, simply find ln8/ln2

(from Wikipedia - the proof also follows if you want to go look it up)

While there are several useful identities, the most important for calculator use lets one find logarithms with bases other than those built into the calculator (usually log

Oct 06, 2009 | Casio FX-300MS Calculator

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

If this is the same manual that you have already ... then apologies!

http://education.ti.com/educationportal/downloadcenter/SoftwareDetail.do?website=US&appId=6115&tabId=2

http://education.ti.com/educationportal/downloadcenter/SoftwareDetail.do?website=US&appId=6115&tabId=2

Apr 13, 2008 | Video Game Consoles & Games

Following formula we can use.

S=P(1+RT)

WHERE S =INVEST AMOUNT+PROFIT

P=INVEST AMOUNT

R= RATE OF RETURN

T=TIME IN YEARS

EX : (300+x) = x(1+(5.4/100)*1)

(300+x)*100 = 105.4x

x=30000/5.4

x=5555. 4

S=P(1+RT)

WHERE S =INVEST AMOUNT+PROFIT

P=INVEST AMOUNT

R= RATE OF RETURN

T=TIME IN YEARS

EX : (300+x) = x(1+(5.4/100)*1)

(300+x)*100 = 105.4x

x=30000/5.4

x=5555. 4

Jan 05, 2008 | The Learning Company Achieve! Math &...

Jan 28, 2016 | Microsoft Excel for PC

115 people viewed this question

Usually answered in minutes!

I still think my formula is wrong.

=SUM(BaseRate*.05)(Opt Yr 1)

How do I get the formula outside the cell to populate for all 4 columns? I know there is a simple way of doing it but I am not getting it correct.

I get ######

how to calculate pf?

×