Page 1 of 2 12 LastLast
Results 1 to 12 of 19

Thread: Pls Helo Me urgently (About Excel)

  1. #1
    Join Date
    07 Jul 2009
    Location
    ملتان
    Gender
    Male
    Posts
    832
    Threads
    118
    Credits
    971
    Thanked
    13

    Default Pls Helo Me urgently (About Excel)


    All Member of It Dunya,
    pls mjhe koi btae Excel me kaise me formula adjust kro mjhe samajh nhi arhe
    me chata ho k jo Colum khali ha waha sale Amount me se Buy Amount ko Minus kar k jo b Raqm ae usko 100 se Multiply kr k wo balance me add ho agr Profit ha ya Minus ho agr Loss ha pls koi mjhe detail se smjha de ya koi r new formula bta de me ne
    Sample sheet atach ke he pls chk ths
    Attached Images Attached Images  
    Attached Files Attached Files
    Last edited by shahleopak; 27th January 2012 at 01:46 PM.

  2. #2
    Join Date
    07 Jul 2009
    Location
    ملتان
    Gender
    Male
    Posts
    832
    Threads
    118
    Credits
    971
    Thanked
    13

    Default

    any member pls help me urgntly
    pls hlp me................

  3. #3
    srkbolly's Avatar
    srkbolly is offline Senior Member+
    Last Online
    9th January 2023 @ 02:47 PM
    Join Date
    24 Jul 2008
    Age
    39
    Posts
    495
    Threads
    97
    Credits
    1,445
    Thanked
    10

    Default

    Boht hi simple hay mere bhai ....

    First aap pahly daikhian kay jin 2 ko aap subtract kr rhy hain woh kon say Alphabet hain?
    jisy Sale ky uper G likha hay or Buy ky uper F likha ..... and kis line ko aap subtract krna chahty hain .. jisy line 9 hay ...
    aap nay yah krna hay kay uper jo fx wali bar hay udhar is tarah likhna hay ...

    =(G9-F9)*100......... then enter ... agar profit hwa to + main aay ga warna - main ...

    umeed hay aap samjh gay hoon gay ..

    Thanks
    °·.?.·°.I LoVe yOu.°·.?.·°

  4. #4
    Join Date
    07 Jul 2009
    Location
    ملتان
    Gender
    Male
    Posts
    832
    Threads
    118
    Credits
    971
    Thanked
    13

    Default

    TTHNX Bro for rply
    ap meri bat smjhe nhi ap ghor se again prhen or File atch ke ha wo b chk karen
    me chata ho k jo b Amount ae Sale se Buy ko minus kr k phr usko multiply karen r jo amount ae wo jo last me Balance dia ha Db/Cr us me ad ho agr profit ha agr loss ha to minus ho jae pls again prhe smjh k jwb den \plssssssssssss we8ng...................

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



    Ap thoda sample data enter karain aur apna expected result bhe manual lekhain ta ka under stand karne m asani ho. Apni modified file ya screen shot thoda update kar dain.

    regards,

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



    Ap thoda sample data enter karain aur apna expected result bhe manual lekhain ta ka under stand karne m asani ho. Apni modified file ya screen shot thoda update kar dain.

    regards,

  7. #7
    Join Date
    07 Jul 2009
    Location
    ملتان
    Gender
    Male
    Posts
    832
    Threads
    118
    Credits
    971
    Thanked
    13

    Default

    bhai jan me ye chata ho k jaise me ne last colum me Db, Cr laya ho ye method me ne Ledger me use kia howa ha
    me International Market mean Gold ke us me Buy amouny me se Sel ke amount nkal k jo amount ae ge usko 100 se multiply karen ge to Pakistani Amount ajae ge pls mjhe thek formula bta den k kaise use kro
    =Open Balnce
    Buy Amount -Sel Amount jo ae ge wo Dolar me ho ge usko 100 se multiply krna ha phr jo amount ae ge wo pakistani rupees me ho ge

  8. #8
    Join Date
    07 Jul 2009
    Location
    ملتان
    Gender
    Male
    Posts
    832
    Threads
    118
    Credits
    971
    Thanked
    13

    Default

    Pls again meri Bat ko samjhe or mjhe formula chaye ya jo ap samjh sken wo bta den apne method se
    Attached Images Attached Images  
    Attached Files Attached Files

  9. #9
    Join Date
    07 Jul 2009
    Location
    ملتان
    Gender
    Male
    Posts
    832
    Threads
    118
    Credits
    971
    Thanked
    13

    Default

    pls any member hlp me

  10. #10
    Join Date
    07 Jul 2009
    Location
    ملتان
    Gender
    Male
    Posts
    832
    Threads
    118
    Credits
    971
    Thanked
    13

    Default

    SYAR bro pls ap hlp karen me apko smjhata ho i.e me ne 1 Lot Buy ke ha Gold ke 1413.00 pr usko sale kr dia 1415.00 jo amount ae ge wo dolar me ho ge phr usko 100 se multiply krna ha phr jo amount ae ge wo profit/loss ho ga or wo profit/loss mere opening balance me se +/- ho jae i.e opening balance ha50,000 is me se comission b minus krna ha i.e 300 umeed ha ap samjh gae ho ge pls ap khd he bna de new format ya jo me ne dia ha us me formula ad kr k de den
    we8ng........................

  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

    Aap k masla ko step by step hal karte hain.

    Pehle aap apna Balance k formula ko check karain k ya kis tarah kam kar raha ha. Is k leye aap Balance k cell ko select karain. Phir Formula k Tab m ja kar "Evaluate Formula" par click karain aur step by step evaluate karin aur apne formula ko dekhain k kis tarah calculate kar raha ha aur necessary changes kar lain.

    Ap ka masla adha hal ho jae ga aur formula ko apne marze k mutabiq dobara write karain. Mere khayal m aap ko sirf +,- ka order change karna ho ga aur profit/loss ka cell bhe mention kar dain.

    Ap ka profit loss ka formula thek ha. Aap apna Balance ka formula set karin. Phir bataye ga.

    regards

  12. #12
    Join Date
    07 Jul 2009
    Location
    ملتان
    Gender
    Male
    Posts
    832
    Threads
    118
    Credits
    971
    Thanked
    13

    Default

    syar BRO MJH SE NHI HO RHA IS LYE AP SE REQUEST KE HA PLS AP MJHE BNA DEN SAMPLE JO AP NE KAHA HA PLSSSSSSSS

Page 1 of 2 12 LastLast

Similar Threads

  1. need help about excel file plzzz help me urgently
    By sarfraz2pk in forum Ask an Expert
    Replies: 3
    Last Post: 3rd February 2011, 07:10 PM
  2. Excel file ka pasward kis terh remove kero pls urgently
    By afrazawan in forum Ask an Expert
    Replies: 9
    Last Post: 8th December 2010, 04:45 PM
  3. Excel Problem Urgently Help
    By shahleopak in forum Ask an Expert
    Replies: 13
    Last Post: 30th September 2009, 12:07 PM
  4. Excel problem urgently help me
    By shahleopak in forum Ask an Expert
    Replies: 19
    Last Post: 8th July 2009, 04:23 PM
  5. urgently help need about Excel
    By smart yousufzai in forum Ask an Expert
    Replies: 2
    Last Post: 2nd April 2009, 06:28 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
  •