Viewing 13 posts - 1 through 13 (of 13 total)
  • OT – Excel help please – Excel v Calculator
  • JohnClimber
    Free Member

    Sorry for the numpty question

    If in A1 is the figure 8.59 and I want to add 3.6% to it I put in box A2 =A1*1.036 and I get 8.899.

    When I put into a calculator 8.59 + 3.6% that equals 8.910

    Please can you tell me which is correct?

    If the Excel one is wrong and the calculator is correct what equation do I use in box A2 on the excel sheet please?

    Many thanks

    jam-bo
    Full Member

    the sum is correct, so do that on your calculator.

    grizedaleforest
    Full Member

    What do you get in your calculator if you do 8.59*1.036?

    Stoner
    Free Member

    In Excel I get 8.89924
    In MS Calculator I get 8.89924
    and on my Casio fx-85 I get 8.89924

    ur doing something rong.

    StirlingCrispin
    Full Member

    My Calculator (MS Windows 7) gives 8.89924

    soobalias
    Free Member

    anybody using a % button on a calculator gets what they deserve.

    JohnClimber
    Free Member

    Sorry I don’t understand your answer

    Are you saying that *1.036 is correct?

    And by adding 3.6% to the 8.59 on the calculator is the wrong way to add percentages to a figure on a calculator.

    Can you tell I was $hite at maths

    scaredypants
    Full Member

    excel is correct, yr calculator iz csio

    jam-bo
    Full Member

    i think everyone is saying the way you are adding 3.6% on the calculator is wrong.

    mine is

    value x 3.6 <shift> <%key> <+key>

    grizedaleforest
    Full Member

    We’re all saying the right answer is 8.9924 so either you’re doing something wrong on your calculator or your calculator is cr$p 🙂

    JohnClimber
    Free Member

    Thanks all

    Sui
    Free Member

    soobalias – Member

    anybody using a % button on a calculator gets what they deserve.

    works on mine (Sharp EL-330ER)

    gonefishin
    Free Member

    anybody using a % button on a calculator gets what they deserve.

    Well not really, it’s about knowing what you are actually asking the calculator to do or RTFM. On my calculator the sum would be

    8.59 x 3.6 % +

    to get the correct answer

    Whereas if you entered

    [value a] + [value b] %

    you get the value of the percentage increase for value a to value b returned.

Viewing 13 posts - 1 through 13 (of 13 total)

The topic ‘OT – Excel help please – Excel v Calculator’ is closed to new replies.