Results 1 to 4 of 4

Thread: Formula for round figure in MS-Excel

  1. #1
    Banto5's Avatar
    Banto5 is offline Senior Member+
    Last Online
    29th August 2019 @ 11:56 PM
    Join Date
    31 Jul 2009
    Location
    Pakistan
    Age
    34
    Gender
    Male
    Posts
    2,332
    Threads
    280
    Credits
    1,094
    Thanked
    136

    Default Formula for round figure in MS-Excel

    Kya hal hai doston mjhe ms-excel k formule k mtalik kchh pchhna hai
    ye formula hai
    196.24*27530.14/1000=5402.51
    ab pchhna ye hai k jo akhr main paise a rhe hai (.51) koi asi commond btao k ye atumatic (.00) ho jae round figure hojae....

  2. #2
    Banto5's Avatar
    Banto5 is offline Senior Member+
    Last Online
    29th August 2019 @ 11:56 PM
    Join Date
    31 Jul 2009
    Location
    Pakistan
    Age
    34
    Gender
    Male
    Posts
    2,332
    Threads
    280
    Credits
    1,094
    Thanked
    136

    Default

    Koi hai jo mri help kre...?

  3. #3
    Join Date
    05 Jan 2008
    Gender
    Male
    Posts
    14,710
    Threads
    673
    Credits
    10,901
    Thanked
    1925

    Default

    یہ راونڈ فگر میں نہیں ہو سکتے کیونکہ اپ اعشاریہ کی رقم بھی کاونٹ کررہے ہیں اگر اعشاریہ والی رقم بھی زیرو ہو تو وہاںزیرو ا سکتا ہے

  4. #4
    Banto5's Avatar
    Banto5 is offline Senior Member+
    Last Online
    29th August 2019 @ 11:56 PM
    Join Date
    31 Jul 2009
    Location
    Pakistan
    Age
    34
    Gender
    Male
    Posts
    2,332
    Threads
    280
    Credits
    1,094
    Thanked
    136

    Default

    mera problume solve ho chuka hai is link ko dekh kar...
    thanks....
    Admin Close This Thread
    Click Here

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. How to remove Formula Link in Excel.
    By Rahmatullah Ktk in forum Ask an Expert
    Replies: 1
    Last Post: 4th April 2016, 12:28 PM
  3. Need help in excel / vlook formula ka istamal
    By imrangadit in forum Ask an Expert
    Replies: 0
    Last Post: 8th January 2013, 07:08 AM
  4. Solved Excel Formula
    By Qutab in forum Solved Problems (IT)
    Replies: 10
    Last Post: 26th January 2012, 08:48 PM
  5. What is Excel Formula for Difference in Two Values ?
    By Baazigar in forum Ask an Expert
    Replies: 2
    Last Post: 30th May 2011, 09:45 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
  •