Question about Microsoft Excel for PC

# FORMULA NEEDED FAST

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!

Posted by on

• 1 more comment
• vhenley Dec 18, 2008

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.

• vhenley Dec 18, 2008

I get ######

• Anonymous Dec 19, 2008

how to calculate pf?

×

• Level 3:

An expert who has achieved level 3 by getting 1000 points

Superstar:

An expert that got 20 achievements.

All-Star:

An expert that got 10 achievements.

MVP:

An expert that got 5 achievements.

• Microsoft Master

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

• Tim Babcock Dec 18, 2008

What happens when you copy the formula to the other cells?

• Tim Babcock Dec 18, 2008

The column isn't long enough or it needs to be formatted for numbers. That will get rid of the ###

×

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).
Good luck!

Posted on Jan 02, 2017

×

my-video-file.mp4

×

## Related Questions:

### How can I calculate the EMI of a business loan

Every borrower can calculate your loan EMI with three methods -
1. Formula Based:you can calculate your loan EMI with the help of given formula-

E = P x r x (1+r)n / ((1+r)n - 1)
where,
E = Each month payable EMI
P = Principal loan amount
r = Rate of interest
n = Duration of the loan

2. Excel Based:
You can also calculate your loan EMI with the help of excel sheet. But before calculating loan EMI, you need to set the above formula in excel sheet.

3.Online EMI calculator:
You can calculate your loan EMI with the help of online business loan EMI calculator . EMI calculators can calculate your loan EMI very easily without any cost.

Feb 21, 2018 | The Computers & Internet

### How can I calculate the EMI of a home loan of 90 lacs?

Banks and Non-Banking Financial Companies use the following formula to calculate EMI of a home loan. This is the formula for calculating compound interest. Applying the same formula for a home loan of Rs 90Lakhs, we get,

EMI = [P x R x (1+R)^N]/[(1+R)^N-1]

Where,
P= Amount borrowed- Here, it will be 90 lakhs
R= Rate of interest per month
N= Number of months in the home loan tenure

Going by the current lending rates followed by the financial institutions, we will consider R to be 9% per annum (to be converted to % per month) and for the loan tenure, we will take 20 years/240 months.

Substituting all values in the above formula, the home loan EMI comes out to be Rs 80,975 per month.

You can easily calculate the EMI for your home loan for any bank or NBFC using a free online Home Loan EMI calculator. You can also find this handy tool on the online portals of most banks and NBFCs. All you have to do is feed in the values in the respective fields and receive the answers.

Oct 09, 2017 | The Office Equipment & Supplies

### How to calculate the payback of a project of uneven cashflows

Hi Mohammed,

You would have to calculate the net cash flow for each year in a projection. Then simply deduct the net cash flow from Yr 1, Yr 2, Yr 3, etc. until you're left with only a partial year. Then you add the same of years (e.g. 4 years) to the quotient of the following:

remaining capex costs / net cash flow in the following year (e.g. Yr 5 if the first part was completed in 4 years).

Apr 27, 2014 | Finance

### Volume of triangular pyramid

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.

Mar 29, 2014 | Office Equipment & Supplies

### Area of traingle with tree side

All triangles have three sides.
There are two main formulas that do not call on trigonometric ratios.
The classic one:
• 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.
Heron's Formula if you have the length of the three sides. Let those measures be a, b, and c.
• 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

### I have a Texas Instruments BAII Plus Professional Calculator. In the course I'm in, I need to know how to calculate the following formula = 1 + 3.3 log (n) The problem is that I can't figure out how to...

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.

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

### I would like to know how to work out currency conversion formula on a normal calculator please

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\$

Oct 13, 2009 | Casio Office Equipment & Supplies

### How to calculate logrithm of base of any number in fx-991ms

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 loge and log10). To find a logarithm with base b, using any other base k:

Oct 06, 2009 | Casio FX-300MS Calculator

### Mathematical Calculation

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

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

#### Related Topics:

116 people viewed this question

Level 3 Expert

Level 3 Expert