+ Reply to Thread
Results 1 to 8 of 8

Calculation Issue

  1. 04-09-2017, 10:26 AM #1
    Imran Shaikh001
    Imran Shaikh001 is offline
    Registered User
    Join Date
    04-09-2017
    Location
    Mumbai
    MS-Off Ver
    2007
    Posts
    2

    Post Calculation Issue

    Hi,

    I am unable to get the exact value in excel with below formula.

    Calculation formula : Basic value + 30% +5.5%+10%+4%*65

    When i tried to compute the value on calculator got the value as 142.857 but in excel value comes as 130 (=J2+(J2*I3%).

    Please assist with formula how to get the exact value.

    Calculation as per calculator
    Basic value of spare $ 100
    Duty 30% 142
    Freight 5.5% 151
    Clearance 10% 167
    Octroi 4% 176
    Current Dollar Value 65
    Total value 11372 INR


    Excel Calculation
    Basic value of spare 100
    Duty 30% 130
    Freight 5.5%
    Clearance 10%
    Octroi 4%
    Current Dollar Value 65
    Total value
    Reply With QuoteRegister To Reply
  2. 04-09-2017, 10:32 AM #2
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,830

    Re: Calculation Issue

    30% of 100 is 30, so 100 plus 30% is 130. How have you and your calculator arrived at 142?
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 04-09-2017, 10:33 AM #3
    cytop
    cytop is offline
    Forum Expert
    Join Date
    02-14-2009
    Location
    .
    MS-Off Ver
    ................
    Posts
    2,840

    Re: Calculation Issue

    Basic value of spare $ 100
    Duty 30% 142
    ...? .
    Reply With QuoteRegister To Reply
  4. 04-09-2017, 11:05 AM #4
    vlady
    vlady is offline
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,361

    Re: Calculation Issue

    as Ali have indicated 30% 0f 100 is 30.

    can you post a mock workbook and what you are doing.
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir
    Reply With QuoteRegister To Reply
  5. 04-09-2017, 11:16 AM #5
    Imran Shaikh001
    Imran Shaikh001 is offline
    Registered User
    Join Date
    04-09-2017
    Location
    Mumbai
    MS-Off Ver
    2007
    Posts
    2

    Re: Calculation Issue

    Yes....

    To get the value we have to follow the formula (Basic value + 30% +5.5%+10%+4%*65) if you compute with calculator value will come 142

    Eg : 100 (basic value) + 30% = 142
    Reply With QuoteRegister To Reply
  6. 04-09-2017, 11:18 AM #6
    vlady
    vlady is offline
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,361

    Re: Calculation Issue

    your basic value is 100 right?
    so you multiply it with 30%. what did you get in your calculator then?
    Reply With QuoteRegister To Reply
  7. 04-09-2017, 11:22 AM #7
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,830

    Re: Calculation Issue

    Your calculator is wrong or you are entering the calculation incorrectly (more likely the latter). Look, it's basic mental maths:

    What is 1% of 100? Easy - divide 100 by 100 and you get 1.
    What is 1 x 30. Easy - that's your one times table and the answer is 30.
    So, if 1% of 100 is 1, then 30% of 100 is 30, and you need to add this to your basic value of 100.
    I'm not Einstein, but I do know that 100+30 is 130, not 142!
    Reply With QuoteRegister To Reply
  8. 04-09-2017, 11:31 AM #8
    vlady
    vlady is offline
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,361

    Re: Calculation Issue

    It's 30 minutes here before midnight.
    your calculator may not be in DEG. try to calculate it manually.

    BTW no offense can I get your age.
    Last edited by vlady; 04-09-2017 at 11:34 AM.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Calculation Time is an issue.
    By aashishkr in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-26-2015, 06:17 AM
  2. Excel 2007 : Calculation issue?
    By Hotte in forum Excel General
    Replies: 6
    Last Post: 09-27-2011, 05:58 AM
  3. Calculation issue with zero
    By Edscuda in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-29-2011, 10:16 AM
  4. Calculation Issue
    By eddiesvoicebox in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-10-2009, 08:14 AM
  5. Strange Calculation issue
    By LACA in forum Excel General
    Replies: 1
    Last Post: 06-18-2006, 04:20 AM
  6. calculation issue?
    By JKC in forum Excel General
    Replies: 6
    Last Post: 03-21-2006, 09:30 AM
  7. [SOLVED] Calculation speed issue
    By Steve M in forum Excel General
    Replies: 4
    Last Post: 01-13-2006, 10:25 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1