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

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

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:

3 Answers

How to calculate interest on fixed deposit if tenor is 3 years?


principle X interest rate X term
deposit by interest rate by the length of the term

Jul 28, 2016 | investopedia.com

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

Steps to figure out formulas in excel


Hello this is Baris,
If you forget about the numbers and start naming your cells you can figure out your own formulas... Example :)

You buy apples, and you pay $2 per piece

in this case you have 2 numbers to find out how much you will pay.

price per apple
quantity

you have 3 apples you pay 6 dollars very simple right. 2 times 3.

Same thing in excel but this time you will just say price times quantity and excel will do the calculation for you.

Lets name your cells
Type in A1 Price
Type in B1 Quantity
Type in C1 Cost

Now, Column C is your calculation area.
Type in A2 2 (price for apples)
Type in B2 3 (quantity of apples)
Type in C2 =A2*C2 (price times quantity)

Now on, you don't have to calculate anything. You can change you price and quantity, cost will change by itself. Because the value in that cell is now related to other values in A2 and B2. I hope this gives you a starting point.

Sep 30, 2009 | Microsoft Excel for PC

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

2 Answers

The % of a discounted price


Lets say Your

MRP = 199
BESTSALE = 130

Now you want to calculate that howmuch percentage of BESTSALE i.e 130, will be added to get MRP i.e. 199.

If m right what do you want, then use the following formula:

Percentage = ((MRP/BESTSALE) - 1) x 100

In your case 199/130 = 1.5307....
So 1.5307 - 1 = 0.5307
Then 0.5307 x 100 = 53.07 %

Thanks
Iqbal

Mar 10, 2008 | Office Equipment & Supplies

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

2720 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18391 Answers

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

Answer questions

Manuals & User Guides

Loading...