Results 1 to 12 of 12

Thread: Excel Help....

  1. #1
    justali's Avatar
    justali is offline Senior Member+
    Last Online
    21st February 2023 @ 03:10 PM
    Join Date
    11 Dec 2010
    Location
    Karachi
    Age
    37
    Gender
    Male
    Posts
    282
    Threads
    37
    Credits
    1,195
    Thanked
    23

    Default Excel Help....


    Dosto ek help chahye excel me ye k me chahta hon k jub me ek cel me 1000 likho tu usi cel me automatic 1.5% add ho k show hojaye.

    ithink yaha se ho sakta hai jahan red mark hai wahan esa koi formula likha jaye
    Name:  1.JPG
Views: 127
Size:  59.7 KB
    Last edited by justali; 19th May 2013 at 01:36 PM.

  2. #2
    justali's Avatar
    justali is offline Senior Member+
    Last Online
    21st February 2023 @ 03:10 PM
    Join Date
    11 Dec 2010
    Location
    Karachi
    Age
    37
    Gender
    Male
    Posts
    282
    Threads
    37
    Credits
    1,195
    Thanked
    23

    Default

    kiya koi help nahi kar sakta

  3. #3
    sayhellotoit's Avatar
    sayhellotoit is offline Senior Member
    Last Online
    23rd September 2017 @ 07:51 PM
    Join Date
    01 May 2009
    Posts
    1,003
    Threads
    5
    Credits
    53
    Thanked
    127

    Default

    Wa-alaikum-assalam,
    Meray khayal say aap aisa chah rahay hain:

    File attach hay.
    Attached Images Attached Images  
    Attached Files Attached Files

  4. #4
    justali's Avatar
    justali is offline Senior Member+
    Last Online
    21st February 2023 @ 03:10 PM
    Join Date
    11 Dec 2010
    Location
    Karachi
    Age
    37
    Gender
    Male
    Posts
    282
    Threads
    37
    Credits
    1,195
    Thanked
    23

    Default

    dost mjhy same cel me result chahye..
    jese me 1000 lekho or same cel me 1015 ajaye

  5. #5
    justali's Avatar
    justali is offline Senior Member+
    Last Online
    21st February 2023 @ 03:10 PM
    Join Date
    11 Dec 2010
    Location
    Karachi
    Age
    37
    Gender
    Male
    Posts
    282
    Threads
    37
    Credits
    1,195
    Thanked
    23

    Default

    koi hai excel expert?????

  6. #6
    justali's Avatar
    justali is offline Senior Member+
    Last Online
    21st February 2023 @ 03:10 PM
    Join Date
    11 Dec 2010
    Location
    Karachi
    Age
    37
    Gender
    Male
    Posts
    282
    Threads
    37
    Credits
    1,195
    Thanked
    23

    Default

    koi hai excel expert?????

  7. #7
    sayhellotoit's Avatar
    sayhellotoit is offline Senior Member
    Last Online
    23rd September 2017 @ 07:51 PM
    Join Date
    01 May 2009
    Posts
    1,003
    Threads
    5
    Credits
    53
    Thanked
    127

    Default

    Meray khayal say ussi cell mein nahi ho sakta.

  8. #8
    justali's Avatar
    justali is offline Senior Member+
    Last Online
    21st February 2023 @ 03:10 PM
    Join Date
    11 Dec 2010
    Location
    Karachi
    Age
    37
    Gender
    Male
    Posts
    282
    Threads
    37
    Credits
    1,195
    Thanked
    23

    Default

    ho sakta hai mere ek dost ne kiya hai

  9. #9
    masroor4u is offline Advance Member
    Last Online
    1st September 2023 @ 09:03 PM
    Join Date
    04 Dec 2012
    Location
    Pakistan
    Gender
    Male
    Posts
    907
    Threads
    52
    Credits
    210
    Thanked
    29

    Default

    Quote justali said: View Post
    ho sakta hai mere ek dost ne kiya hai
    men ne kbi usi cell men try nhn kiya, ore ye kesa dost hy jisne khud kia hy or apko nhn bata raha, usi cell men kyn zaruri hy?

  10. #10
    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

    Quote justali said: View Post

    Dosto ek help chahye excel me ye k me chahta hon k jub me ek cel me 1000 likho tu usi cel me automatic 1.5% add ho k show hojaye.

    ithink yaha se ho sakta hai jahan red mark hai wahan esa koi formula likha jaye
    Name:  1.JPG
Views: 127
Size:  59.7 KB
    Formula k through tu mushkil ha mumkin nahee ha. Agar aap k cell specified hain k kisi makhsoos cell m lekhain aur 15% or etc add ho jae tu try VB code. Pore sheet k leye bhe mumkin ha lekan is m risk ya ha k aap ka excel CRASH kar jae ga. if you are familiar with VB code then take a look

    http://www.itdunya.com/t300546-45/

    Post NO. 540 aur is sa age pechy bhe study karain, May be your problem solved.

    regards

  11. #11
    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

    Or follow the following procedure

    1. Open your sheet jis p aap n entry krne ha
    2. Sheet k name p right click karain aur View Code p click karain
    3. Open hone wale window m ya code paste karain
    Code:
    Private Sub Worksheet_Change(ByVal Target As Range)
    Dim dblVal As Double, rngInterest As Range, lngCount As Long
    On Error GoTo ExitPoint
    Application.EnableEvents = False
    Set rngInterest = Intersect(Target, Range("A1:A20"))
    lngCount = Application.WorksheetFunction.CountA(rngInterest)
    If lngCount Then
        dblVal = Val(rngInterest(1).Value)
        Application.Undo
        If lngCount = 1 Then
            rngInterest.Value = dblVal + (dblVal * 0.015)
        Else
            MsgBox "Multiple Updates Not Permitted", vbCritical, "Computer Says No"
        End If
    End If
    ExitPoint:
    Set rngInterest = Nothing
    Application.EnableEvents = True
    End Sub
    4. vb code ki window close kar dain.
    5. remeber ya code sirf range A1:A20 p kam kara ga. Aap chahain tu code modify kr k range adjust kar lain.

    NOTE 1: agar aap ya chahte haain k kisi bhe cell m entry karain aur wo auto add krta chala jae tu as mention above aap ka excel crash kar jae ga aur its not recomended. aap apne range decide kr lain phr ya code apply krya ga.

    2. Macro k program enter krne k leye aur sekhne k leye aap EXCEL help line ko visit krain aur us m faisal Sahib ki posts ko study karain unhon n detail sa macro programming krna btaya ha.


    regards,

  12. #12
    justali's Avatar
    justali is offline Senior Member+
    Last Online
    21st February 2023 @ 03:10 PM
    Join Date
    11 Dec 2010
    Location
    Karachi
    Age
    37
    Gender
    Male
    Posts
    282
    Threads
    37
    Credits
    1,195
    Thanked
    23

    Default

    thanks syar i will try

Similar Threads

  1. Answered MS Word Ki file ko JPG me kesy convert kru?
    By 1heart2pain in forum Ask an Expert
    Replies: 10
    Last Post: 24th May 2010, 02:34 AM
  2. Excel 2003 for Starters: The Missing Manual
    By oralover2006 in forum English IT Zone
    Replies: 2
    Last Post: 28th May 2009, 11:01 AM
  3. MicroSoft Excel short cuts
    By khurshid akhtar in forum General Discussion
    Replies: 1
    Last Post: 17th January 2008, 02:58 PM
  4. MS Office 2000 Shortcut Keys
    By general in forum General Discussion
    Replies: 4
    Last Post: 31st May 2007, 04:07 PM
  5. Excel Shortcut Keys
    By cuticle in forum General Discussion
    Replies: 3
    Last Post: 29th January 2007, 07:45 AM

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
  •