Results 1 to 7 of 7

Thread: Excel Problem

  1. #1
    ismailshadab's Avatar
    ismailshadab is offline Senior Member+
    Last Online
    24th May 2012 @ 07:21 PM
    Join Date
    26 Nov 2007
    Location
    The City Of Beauty
    Age
    39
    Posts
    547
    Threads
    110
    Credits
    970
    Thanked
    0

    Cool Excel Problem

    Agar hamaray pass 25 items hoon aur usky unite price 45.23 hoo, tho agar
    hum usky total price maloom karna chahain to (25*45.23) 25 ko 45.23 say
    multiply karain gain tho result yeh hoga..(25*45.23=1130.75)

    jabkah main chahta hoon keh jub hum 25 ko 45.23 say multiply karain to
    result 1131 ana chahay (25.45.23=1131). Means, agar fils 50 say ziada hain
    tho woh 1 rupee main convert ho jay..........

    Agar kesy ko iska hall maloom ho tho zaroor reply karani



    Aap ka bai........

    Ismail Shadab
    [IMG]http://i735.***********.com/albums/ww356/charernkitsell/5491432.jpg[/IMG]

  2. #2
    Join Date
    16 Jul 2009
    Location
    (¯`·._.•!TD•._.·´¯)*(¯`·._.•HUJRÕ._.·´¯)
    Posts
    2,452
    Threads
    214
    Credits
    39
    Thanked
    84

    Default

    Computer Rounding Off nahi karta, agar value 50 sy zyada aaye to usay khud he hum 1 he count kertay hen
    J say aap nay 1130.75 answer aya hay, to aap isay 1131 he count karen, COmputer/Excel/Calculator aapko 1131 ka result nahi day ga.
    Ye aap KHud Suppose karen.

    From
    Salman

  3. #3
    moon_6432000's Avatar
    moon_6432000 is offline Senior Member+
    Last Online
    1st January 2024 @ 08:06 AM
    Join Date
    18 Jul 2008
    Location
    Kamra, Attock
    Age
    38
    Gender
    Male
    Posts
    530
    Threads
    13
    Credits
    129
    Thanked
    25

    Default

    Ismail shadab bahi !
    app ka msla itna moshkil nahi hae app ko jo steep man batane jara hoon us ko samaj kar apply karen app ka masla hal ho jae ga.
    karna ye hae app ne k jis man man app ka answer aya hae us cell man click karen aur "decrease decimal" par click karen jo k app ko formating tool bar man mele ga. 2 martaba click karne se app ka jawab 1131 ajye ga jab tak app jawab .50 ya is se zeyada nahi ho jata tab tak koch add nahi ho ga app try karen aur pir moje reply karen agar koch masla ho to zaror batana.Name:  excel1.JPG
Views: 277
Size:  5.6 KB

    man nae ye attachment be send ki hae.

  4. #4
    syar is offline Advance Member
    Last Online
    14th March 2024 @ 07:49 PM
    Join Date
    31 Jul 2009
    Location
    Nowshera(KP)
    Age
    47
    Gender
    Male
    Posts
    882
    Threads
    9
    Credits
    548
    Thanked
    340

    Default

    salam::
    try with round function like

    =round(25*45.23,0)

    or replace with
    =round(a1*b1,0)

    also look at excel builtin help for ceiling,floor,trunc,roundup etc
    may be this will help you.

    regards

  5. #5
    Join Date
    07 Sep 2009
    Location
    *~"KUWAIT"~*
    Age
    40
    Gender
    Male
    Posts
    1,365
    Threads
    83
    Credits
    0
    Thanked
    142

    Default


    Is tariqa se app fills ka ezafa ya phit kami ker sakte hain...
    Attached Images Attached Images  

  6. #6
    jaadoogar is offline Member
    Last Online
    27th March 2010 @ 06:13 PM
    Join Date
    25 Oct 2008
    Location
    Jadu Nagri
    Age
    43
    Posts
    543
    Threads
    48
    Thanked
    30

    Default

    Try to Mr.Syar's Formula

  7. #7
    ismailshadab's Avatar
    ismailshadab is offline Senior Member+
    Last Online
    24th May 2012 @ 07:21 PM
    Join Date
    26 Nov 2007
    Location
    The City Of Beauty
    Age
    39
    Posts
    547
    Threads
    110
    Credits
    970
    Thanked
    0

    Default

    Tamam Baion..............ka..............bohat.......... ...shukriya...........

Similar Threads

  1. Excel PDF Problem
    By rafiquey in forum Ask an Expert
    Replies: 7
    Last Post: 1st September 2015, 08:49 PM
  2. Solved excel problem plz help
    By nissa in forum Solved Problems (IT)
    Replies: 7
    Last Post: 12th May 2015, 12:54 PM
  3. Excel Problem
    By Qutab in forum Ask an Expert
    Replies: 17
    Last Post: 18th July 2012, 09:01 PM
  4. excel problem
    By Iqbalpk in forum Ask an Expert
    Replies: 2
    Last Post: 26th May 2012, 09:05 AM
  5. Excel problem
    By shahleopak in forum Ask an Expert
    Replies: 12
    Last Post: 23rd July 2009, 02:14 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
  •