Computers & Internet Logo

Related Topics:

J
Joyce Kohn Posted on Mar 26, 2017
Answered by a Fixya Expert

Trustworthy Expert Solutions

At Fixya.com, our trusted experts are meticulously vetted and possess extensive experience in their respective fields. Backed by a community of knowledgeable professionals, our platform ensures that the solutions provided are thoroughly researched and validated.

View Our Top Experts

Setting up a formula. I am comparing amounts for the last 3 years of raises and want to figure 5 different ones this year.Example of what I am trying to do. =(F6:F18*1.12%+F6:F18) Can this be done?

1 Answer

Brett Duxbury

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.

  • The Master 4,352 Answers
  • Posted on Mar 26, 2017
Brett Duxbury
The Master
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.

Joined: Nov 12, 2012
Answers
4352
Questions
0
Helped
1119175
Points
13423

In excel ?
=sum(f6:f18)*0.012+sum(f6:f18)
if each row has to be individually * 0.012 add a column and put in this column each row cell * 0.012. example new column G then g6=f6+f6*0.012
a screen print of what you are trying to do would give a clearer indication of exactly what you want to achieve ?

5 Related Answers

Anonymous

  • 2 Answers
  • Posted on Oct 25, 2007

SOURCE: Excel Formula

Use the round() function to specify how many decimal places you want to display.  From the example you provided above, you could use the following formula:

=ROUND(SUM(A1:A4)*1.07,2)

The final "2" specifies that you want to display two digits to the right of the decimal point.

Ad

Ekse

  • 13435 Answers
  • Posted on Jun 30, 2008

SOURCE: Venturer 5 CD Player

you have to take it apart to see whats obstructing it possibly inside.

Well seems it has lasted a long time with you, so you don't have much to loose.

Anonymous

  • 1 Answer
  • Posted on Feb 22, 2009

SOURCE: My Kodak ESP 5 Won't print entire documents, only first page

Scott,  If you are using Mac and Adobe 8 or 9, see solution from Kodak site at:
http://www.kodak.com/eknec/PageQuerier.jhtml?pq-path=12998/7269&pq-locale=en_US

Patrick Rayome

  • 1757 Answers
  • Posted on Mar 01, 2010

SOURCE: Belt Routing Figure for 1994 Toyota Landcruiser

CLICK on the following LINK. It has all the Diagrams for your Belt that you will need.
If you would: Before Clicking let me know if this helped you, or if you have any additional information or questions. Feel Free to contact me at FixYa.com!
Thanks!

http://www.2carpros.com/car_repair_information/year/1994/make/toyota/model/land_cruiser/1994_toyota_land_cruiser_drive_belt_routing_diagram.htm

salt56

TV Doctor

  • 373 Answers
  • Posted on Jul 15, 2011

SOURCE: I REPLACED RCA D52W19 CAPACITORS

You have a bad flyback transformer. This is a common problem that eventually goes bad in the ITC 222 chassis. You have to get the model number with the code at the end of it after the /. And sometimes you must have the numbers from off the flyback itself. Try to contact MCM electronics for the flyback at 1-800-543-4330. First see if they can match it with the model number with the code after the /.

Testimonial: "YES SIR YOU ARE RIGHT YEAH THANKS FOR ALL THE HELP"

Ad

Add Your Answer

×

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

0helpful
2answers

What is the method of calculating interest rate for fixed deposit?

Fixed deposit calculations can be done by both manual and automatic methods.Now let us figure out the fd calculation in both ways:
1.) Manual Calculation Technique: It is the conventional process to know your Fixed deposit interest calculation. The formula for manual fd calculation is used as below:

Where,A = Final Amount
P = Principal Amount (initial investment)
r = Annual Nominal Interest Rate (as a decimal, not in percentage)
n = Number of times the interest is compounded per year
t = Number of years

2.) Online Calculator Technique: Nowadays online FD calculator is very amazing technique and it is a very useful online tool that helps you to easily calculate your Fixed deposit return. Online FD calculators uses simple technique in which you need to put your amount, tenure, interest rate and can get accurate results instantly. You can easily calculate and compare the interest receivable by changing the deposit amount.
Mar 18, 2018 • Finance
0helpful
1answer

What is the formula to figure 4% daily on 380,000.00 ? Or on any amount ?

premium X % X time
so 380,00000 X4/100 X 1 year
it calculated as the amount ( premium ) multiplied by the percentage of 100 multiplied by the period in years or parts of a year
so it can be 100 X 25% or 1/4(25/100) by the period (5 years or daily (1/365 of a year)
This is known as simple interest
compound interest is calculated on remaining premium after payment X the interest rate by the day or week or month
so for example 100 X 4/100 X 1/12 is the first calculation for the month and for the next month the calculation will be premium of 80 ( if a 20 payment was made in the month X 4/100 X 1/12 and so on if payment are made on time
pm the other hand if no payment are made then the premium goes up by the interest rate
so for the next month it is 104 X 4/100 X 1/12 and the month after that 108.16 X 4/100 X 1/12.and so on
banks use compound when calculating home loan repayments and simple interest when paying interest on your deposits
( has to be in the bank for 367 days to get the interest paid )
0helpful
1answer

How to reset date on royal cash register model alpha 710ml

Page 7

To set the date
1 At the prompt, use the rounded Number keys to enter the last 2 digits of
the year. For example, for 2006, press 06. Press the Amount Tend Total
<Enter> key.
2 Use the rounded Number keys to enter the 2 digits of the month. For
example, for February, press 02. Press the Amount Tend Total <Enter>
key.
3 Use the rounded Number keys to enter the 2 digits of the day. For
example, 24. Press the Amount Tend Total <Enter> key.
4 Use the rounded Number keys to enter the 2 digit hour. For example,
09. Use military, or 24 hour, time for hours after 12 noon. For example,
if you want to enter 8pm, press 20. Press the Amount Tend Total
<Enter> key.
5 Use the rounded Number keys to enter the 2 digits of the minutes. For
example, 54. Press the Amount Tend Total <Enter> key.
Using the information in this example, the date and time are set to
02-24-06 8:54pm.


http://www.royalsupplies.com/cashreg/Instruction%20Manual%20A710ML%20Eng%20ver11%20GOLD3.pdf
0helpful
1answer

I raised $948,963 last year. I raise $ 817,430 this year. Is that 9% less raised this year>

No.
You can divide this years by last year and that gives you the percent you got this year compared to last. You raised about 86 percent of what you raised last year. so 100 percent minus 86 percent. That is equal to 14 percent. You raised 14 percent less this year.
0helpful
1answer

BEST WAY TO SET UP IF/OR FUNCTION IN EXCEL FOR MAC 2004

Formula :
=If (F7<>"", (IF (H7<>"",H7-F7,"")),"")

Sometimes you need to use the opposite comparison, like instead of being equal to "" try to compare it if it's not equal to "". The formula above should work with no problem. Good luck :)
0helpful
1answer

DATE DIFERANCE BETWEEN SELECTED COLOUMN

Are you trying to figure the difference in days between these dates and one single date (Dec. 31, 2008 for example)?

Whatever you're trying to do, here is the formula, assuming you're starting in A1:
Put the first date in the format Day-Month-Year in numbers (Sept. 3 is 03-09-2008)
Then put your other date in B1, in Day-Mo-Yr format (31-12-2008 for Dec. 31, 2008)
In C1 put B1-A1 and that will give you the number of days between those two dates.
3helpful
4answers

I want the excel compound interest formula

=10000*(1+0.96)^12
=10000*(1+0.10)^18
=10000*(1+0.10)^24
0helpful
1answer

Need to Add Dates in Excel

Here is one way I just tried:

Say the date purchased is in A1.

You want the Est Life in A2.

In A2 type: =A1+(3*365)
That will add 3 years.

For 5 years: =A1+(5*365)

Try it out!

Note: You will need to format the cells to Custom>mm/dd/yyyy
0helpful
3answers

Formulas

meri excel file ka security paasward missing. Pls i want track the paasward.
Not finding what you are looking for?

89 views

Ask a Question

Usually answered in minutes!

Top The Computers & Internet Experts

Alexander

Level 2 Expert

171 Answers

nexrad_chris

Level 2 Expert

177 Answers

vince

Level 3 Expert

2530 Answers

Are you a The Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...