Results 1 to 8 of 8

Thread: excel formula ??

  1. #1
    rafiquey is offline Senior Member+
    Last Online
    7th March 2024 @ 10:15 AM
    Join Date
    13 Feb 2007
    Posts
    431
    Threads
    191
    Credits
    1,691
    Thanked
    15

    Default excel formula ??

    In excel sheet, if i put 12,000 in one cell how i can get 100,000/- in another cell.
    please explain with formula.

    if i multyply 12000*8.333333/10=99,999.99 which is equal to 100,000/-
    my actual question is how 8.333333 has calculated.

    Thanks
    Last edited by rafiquey; 6th November 2018 at 03:20 PM.

  2. #2
    KingKhan84's Avatar
    KingKhan84 is offline Advance Member
    Last Online
    23rd August 2023 @ 03:59 PM
    Join Date
    08 Mar 2017
    Gender
    Male
    Posts
    1,814
    Threads
    73
    Credits
    11,419
    Thanked
    79

    Default

    Quote rafiquey said: View Post
    In excel sheet, if i put 12,000 in one cell how i can get 100,000/- in another cell.
    please explain with formula.

    if i multyply 12000*8.333333/10=99,999.99 which is equal to 100,000/-
    my actual question is how 8.333333 has calculated.

    Thanks
    why you divided by 10 ???

    Further the simple forumula is divide 100,000 by 12000 and you will get the actual / require value
    Attached Files Attached Files
    Desert Rose
    A Simple Person With Complicated Mind

  3. #3
    rafiquey is offline Senior Member+
    Last Online
    7th March 2024 @ 10:15 AM
    Join Date
    13 Feb 2007
    Posts
    431
    Threads
    191
    Credits
    1,691
    Thanked
    15

    Default

    kindly check this file and help me out to find out 8.33333 rate
    Thanks
    Attached Files Attached Files

  4. #4
    rafiquey is offline Senior Member+
    Last Online
    7th March 2024 @ 10:15 AM
    Join Date
    13 Feb 2007
    Posts
    431
    Threads
    191
    Credits
    1,691
    Thanked
    15

    Default

    یہ 12000 کی رقم میں نے مثال دینے کے لئے لکھی ہے۔ کچھ کمپنیوں سے مختلف ٹیکس چالان ملتے ہیں، جیسے کہ 2،300 ، 1538،1890 وغیرہ۔
    چونکہ میرے پاس صرف ٹیکس چالان ہو تا ہے اس لئے یہ معلوم کرنا ہے کہ اصل رقم کتنی تھی جس پر یہ ٹیکس کاٹا گیا ہے۔
    شکریہ۔
    Attached Files Attached Files

  5. #5
    KingKhan84's Avatar
    KingKhan84 is offline Advance Member
    Last Online
    23rd August 2023 @ 03:59 PM
    Join Date
    08 Mar 2017
    Gender
    Male
    Posts
    1,814
    Threads
    73
    Credits
    11,419
    Thanked
    79

    Default

    Quote rafiquey said: View Post
    یہ 12000 کی رقم میں نے مثال دینے کے لئے لکھی ہے۔ کچھ کمپنیوں سے مختلف ٹیکس چالان ملتے ہیں، جیسے کہ 2،300 ، 1538،1890 وغیرہ۔
    چونکہ میرے پاس صرف ٹیکس چالان ہو تا ہے اس لئے یہ معلوم کرنا ہے کہ اصل رقم کتنی تھی جس پر یہ ٹیکس کاٹا گیا ہے۔
    شکریہ۔
    I think your problem is solved... check the file and enter only tax / challan amount
    Attached Files Attached Files

  6. #6
    rafiquey is offline Senior Member+
    Last Online
    7th March 2024 @ 10:15 AM
    Join Date
    13 Feb 2007
    Posts
    431
    Threads
    191
    Credits
    1,691
    Thanked
    15

    Default

    Thank You brother, & stay blessed, in some how it has solved my problem.
    جزاک اللہ

  7. #7
    Haseeb Alamgir's Avatar
    Haseeb Alamgir is offline Super Moderator
    Last Online
    Yesterday @ 10:43 PM
    Join Date
    09 Apr 2009
    Location
    KARACHI&
    Gender
    Male
    Posts
    19,307
    Threads
    412
    Credits
    39,753
    Thanked
    1813

    Default

    مسلہ حل ہونے پر مبارک باد قبول فرمائے
    اگر
    اپنا مسلہ درست انداز میں شئیر کریں گے تورہنمائی کرنے والے کو آسانی ہوتی ہے
    اب
    آپ کے دونوں تھریڈز جو کہ ایک ہی مسلے کےلئے بنائے گے تھے
    بند کرنے کی شفارش کی جاتی ہے

  8. #8
    Join Date
    26 Mar 2010
    Location
    Lahore
    Gender
    Male
    Posts
    10,601
    Threads
    2397
    Credits
    107,695
    Thanked
    1656

    Default

    Closed.
    & moved.

Similar Threads

  1. Excel tip (Hidde formula in formula bar in excel)
    By Honour12 in forum Urdu Tutorials & Designing
    Replies: 14
    Last Post: 31st May 2016, 10:06 AM
  2. Need help in excel formula
    By zaidi91 in forum Ask an Expert
    Replies: 0
    Last Post: 23rd February 2015, 01:08 PM
  3. Solved Help a excel formula?
    By Ameen Asim in forum Solved Problems (IT)
    Replies: 8
    Last Post: 25th November 2011, 09:20 PM
  4. I need formula in excel
    By adnanbahrian in forum Ask an Expert
    Replies: 13
    Last Post: 22nd April 2010, 06:24 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
  •