Question about Microsoft Excel for PC

1 Answer

Odd change added to an even dollar calculation

I am getting odd change amounts added to even dollar and number calculations,..all sells and formulas are even amounts but the values on the right of the decimal are not .00. As I change my figures for calculating this changes but it should always be .00 not .88 or .63.
Can't locate the problem.

Posted by on

Ad

1 Answer

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Master:

    An expert who has achieved Level 3.

  • Master
  • 409 Answers

If you look in the options you will find a setting that says "precision as shown" turn that on and it should cure your problem

Posted on Jul 24, 2009

Ad

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 there,
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this 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.

Here's a link to this great service

Good luck!

Posted on Jan 02, 2017

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1 Answer

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

2 Answers

How can I calculate the EMI of a business loan


Availing a Business Loan in Bangalore is a most benefitted opportunity for the entrepreneurs. It is good to know that now accessing the Business loan is more relaxed from the online lending marketplace Rupee Station. How is it? Find in the following points:

1. Rupee Station has a free EMI calculator tool where the borrower can use to get 100% accurate results through the end of theirs.

2. It is quite easy to use through the graphical representation by providing the also instant calculating results and brief about the loan repayment process as well.
Read More: Get Startup Work Loan in Bangalore
Rupee Station is the digital lending marketplace where you can avail the hassle-free financial support.

business loan in bangalore-egjo0rr0xece0m52q30i5boj-5-0.jpg

Feb 21, 2018 | The Computers & Internet

1 Answer

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

2 Answers

What is formula to find percentage of females in my workplace?


      To get around this, you can calculate your numbers as percentages first. For example, if you type the formula =10/100 in cell A2, Excel will display the result as 0.1. If you then format that decimal as a percentage, the number will be displayed as 10%, as you 'd expect.Aug 2, 2011

      How to do percentages in Excel - Office Blogs

      https://blogs.office.com/2011/08/02/how-to-do-percentages-in-excel/
    Feedback

    How to Calculate Percentages in Excel

    www.excelfunctions.net > Excel-Formulas
    Two Percentage Calculation Types. Calculate a Percentage as a Proportion.Calculate Percentage Change. Displaying Percentages in Excel Cells ...

    Excel formula: Get percentage of total ' Exceljet

    https://exceljet.net/formula/get-percentage-of-total
    Excel simply divides the values in column C by the total in C11. For the formula shown, the result is the decimal number .63. Because the Percentage number format is applied to cell E6, Excel displays .63 as 63%.

Jan 19, 2016 | Computers & Internet

1 Answer

HOW CAN I INSERT THE EQUASIONS IN TO CASIO FX-85GT PLUS, SO IN THE EXAM I WILL EDIT THE NUMBERS ONLY?


Same question, same answer.
Sorry, but you cannot.
You can type in a formula that involves the memory variables X,Y, A, B,C,D, E, =, . Such a formula is meant to be evaluated to get a solution (X by default). Once you type the formula you press the Shifted function SOLVE and you will be prompted for the constants, for Y etc. when you press the EXE/= key you get the value of X.
If you turn off the calculator or change the calculation MODE, it is wiped out of memory.

To make a long story short, you cannot STORE formulas in the calculator. Better try to memorize them (commit then to YOUR OWN memory).

May 20, 2011 | Casio fx-300ES 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

Need a formulae for 'Interest calculation' for 'Over-draft loan'


Try this formula=((A1)*(1+A2))-A3 Where: A1 is the original Balance A2 is the interest rate A3 is the money paid for the preceding month

Apr 02, 2009 | Microsoft Excel for PC

2 Answers

TI 83


Yes you can use it, here is the formula: Y= V(t+ (i/c))^(tc) V=amount put in, t=time, i=intrest rate, c= amount of times it is compounded.
(I know this because I have a TI-83 calculator)

Mar 27, 2009 | Texas Instruments TI-83+ Graphing...

2 Answers

Can't reopen circular reference file in excel


  1. Click the Microsoft Office Button , click Excel Options, and then click the Formulas category.
  2. In the Calculation options section, select the Enable iterative calculation check box.
  3. To set the maximum number of times that Excel will recalculate, type the number of iterations in the Maximum Iterations box. The higher the number of iterations, the more time that Excel needs to calculate a worksheet.
  4. To set the maximum amount of change you will accept between calculation results, type the amount in the Maximum Change box. The smaller the number, the more accurate the result and the more time that Excel needs to calculate a worksheet.

Nov 05, 2008 | Microsoft Excel for PC

1 Answer

Calculated field in Excel pivot


Count will only work with numbers. So select another box where you want your number and use this formula: =count(x:x) This should give the count number then you will need to find the difference. In another box, use =sum(x-x). This should give you your difference.


If this helps you, please rate me. Thanks, Patty

Dec 17, 2007 | Computers & Internet

Not finding what you are looking for?

Open Questions:

See all Microsoft Excel for PC Questions

Microsoft Excel for PC Logo

100 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

3015 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18424 Answers

Alun Cox

Level 3 Expert

2678 Answers

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

Answer questions

Manuals & User Guides

Loading...