Question about Microsoft Excel for PC

1 Answer

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?

×

1 Answer

  • 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
  • 2,794 Answers

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
    Tim Babcock Dec 18, 2008

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

  • Tim Babcock
    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 ###

×

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

I have a vehicle which have moved for 2383 kilo meters and used 320 liters of diesel what should be the consumption rate


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

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

1 Answer

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

913b74c4-c453-4afa-be3a-c3e781816e8d.png

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)
bc7a3bcd-ec6e-4936-9887-c6372904fe9f.png

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.
1fbf065d-6c1d-440a-9069-783127aa9842.png

Mar 29, 2014 | Office Equipment & Supplies

1 Answer

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

1 Answer

How to calculate interest rate based on original balance and payment amount using BA II Plus


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

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

1 Answer

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

2 Answers

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

2 Answers

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:
d6ebf1f1efb6ddc379bc68d1ff0c0447.png

Oct 06, 2009 | Casio FX-300MS Calculator

2 Answers

I need help with a change of base formula problem.


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

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

1 Answer

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

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

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