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

Thread: Please Help in Excel Fourmula...

  1. #1
    seven86's Avatar
    seven86 is offline Advance Member
    Last Online
    25th April 2017 @ 06:12 PM
    Join Date
    27 Nov 2008
    Location
    Karachi
    Gender
    Male
    Posts
    1,964
    Threads
    48
    Credits
    241
    Thanked
    65

    Post Please Help in Excel Fourmula...


    مجھے ایکسل فارمولے کے لئے مدد چائیے
    ایکسل کی فائل اٹیچ کی ہے۔
    ٹوٹل ویلیو میں سے ایک دفعہ ڈسکائونٹ مائنس ہوگا اور پھر اسمیں سے بونس مائنس ہوگا۔
    اور دوسرے میں ایک دفعہ ڈسکائونٹ مائنس ہوگا اور پھر اس میں سے تقسیم ہوگا بونس پرسنٹیج میں۔

    شکریہ۔۔۔
    Attached Files Attached Files
    [SIGPIC][/SIGPIC]

  2. #2
    Join Date
    08 Mar 2017
    Age
    32
    Gender
    Male
    Posts
    400
    Threads
    19
    Credits
    2,425
    Thanked
    30

    Default

    Quote seven86 said: View Post

    مجھے ایکسل فارمولے کے لئے مدد چائیے
    ایکسل کی فائل اٹیچ کی ہے۔
    ٹوٹل ویلیو میں سے ایک دفعہ ڈسکائونٹ مائنس ہوگا اور پھر اسمیں سے بونس مائنس ہوگا۔
    اور دوسرے میں ایک دفعہ ڈسکائونٹ مائنس ہوگا اور پھر اس میں سے تقسیم ہوگا بونس پرسنٹیج میں۔

    شکریہ۔۔۔
    I think pehli row ka problem to solve ho gaya but second row wali thori aur details batao ye kuch khas samjh nahi aaya
    Attached Files Attached Files
    Desert Rose
    A Simple Person With Complicated Mind

  3. #3
    seven86's Avatar
    seven86 is offline Advance Member
    Last Online
    25th April 2017 @ 06:12 PM
    Join Date
    27 Nov 2008
    Location
    Karachi
    Gender
    Male
    Posts
    1,964
    Threads
    48
    Credits
    241
    Thanked
    65

    Default

    Quote SajjadKhan84 said: View Post
    I think pehli row ka problem to solve ho gaya but second row wali thori aur details batao ye kuch khas samjh nahi aaya
    Thanks for reply...
    aap ki calculation main ans wrong hey, 1st row main...
    2nd row main divided by 120% ho ga discount main sey....

  4. #4
    Join Date
    08 Mar 2017
    Age
    32
    Gender
    Male
    Posts
    400
    Threads
    19
    Credits
    2,425
    Thanked
    30

    Default

    Quote seven86 said: View Post


    Thanks for reply...
    aap ki calculation main ans wrong hey, 1st row main...
    2nd row main divided by 120% ho ga discount main sey....
    Bhai aap details nahi bata rahe to koi bhi apke help nahi kar sake ga pls details batao or her cell me calculation manual kardo to him formula laga denge

  5. #5
    Join Date
    08 Mar 2017
    Age
    32
    Gender
    Male
    Posts
    400
    Threads
    19
    Credits
    2,425
    Thanked
    30

    Default

    Quote seven86 said: View Post

    مجھے ایکسل فارمولے کے لئے مدد چائیے
    ایکسل کی فائل اٹیچ کی ہے۔
    ٹوٹل ویلیو میں سے ایک دفعہ ڈسکائونٹ مائنس ہوگا اور پھر اسمیں سے بونس مائنس ہوگا۔
    اور دوسرے میں ایک دفعہ ڈسکائونٹ مائنس ہوگا اور پھر اس میں سے تقسیم ہوگا بونس پرسنٹیج میں۔

    شکریہ۔۔۔
    Received your PM but ap se requset hai ke aap apni problem thori aur tafseel se bataye ager mujh se na ho saka to koi aur expert aap ke help kardega.... Thanks

  6. #6
    seven86's Avatar
    seven86 is offline Advance Member
    Last Online
    25th April 2017 @ 06:12 PM
    Join Date
    27 Nov 2008
    Location
    Karachi
    Gender
    Male
    Posts
    1,964
    Threads
    48
    Credits
    241
    Thanked
    65

    Default

    Quote SajjadKhan84 said: View Post
    Received your PM but ap se requset hai ke aap apni problem thori aur tafseel se bataye ager mujh se na ho saka to koi aur expert aap ke help kardega.... Thanks
    Thanks for Reply...

    Total value 648 -18% for discount = 531.36 - 2% for bonus = 520.73 (is right ans.)
    Total Value 648 - 18% for discount = 531.36 120% for bonus = 442.80 (is right ans.)

    is calculation key hissab sey excel per formula bana dain...

    thanks & regards...

  7. #7
    Join Date
    08 Mar 2017
    Age
    32
    Gender
    Male
    Posts
    400
    Threads
    19
    Credits
    2,425
    Thanked
    30

    Default

    Now Check.

    Maine E , F , G column mai kuch formula lagaye hai , wo zaror copy / paste kardia karo ager new calculation karni hoto... or oska color white kardia hai taake ager aap print lo to wo nazar na aye

    Behtar yahi hai ke aap coloumn A to G copy karke new line mai paste karo or sirf value input karo.... any question pls ask
    Attached Files Attached Files

  8. #8
    Join Date
    08 Mar 2017
    Age
    32
    Gender
    Male
    Posts
    400
    Threads
    19
    Credits
    2,425
    Thanked
    30

    Default

    Quote seven86 said: View Post


    Thanks for Reply...

    Total value 648 -18% for discount = 531.36 - 2% for bonus = 520.73 (is right ans.)
    Total Value 648 - 18% for discount = 531.36 120% for bonus = 442.80 (is right ans.)

    is calculation key hissab sey excel per formula bana dain...

    thanks & regards...
    Aap ne updated file check kee ??

  9. The Following User Says Thank You to SajjadKhan84 For This Useful Post:

    seven86 (24th April 2017)

  10. #9
    Adeel_Boss's Avatar
    Adeel_Boss is offline ITD WINNER
    Last Online
    25th April 2017 @ 01:16 PM
    Join Date
    08 Dec 2013
    Location
    Heart-Beat
    Age
    21
    Gender
    Male
    Posts
    668
    Threads
    77
    Credits
    125
    Thanked
    23

  11. #10
    Ranjha123 is offline Junior Member
    Last Online
    24th April 2017 @ 02:20 PM
    Join Date
    15 Jan 2016
    Age
    22
    Gender
    Male
    Posts
    8
    Threads
    0
    Credits
    36
    Thanked
    0

    Default

    excel ki short key sekhna ka leya koi link bta sakta ha online ho

  12. #11
    Join Date
    08 Mar 2017
    Age
    32
    Gender
    Male
    Posts
    400
    Threads
    19
    Credits
    2,425
    Thanked
    30

    Default

    Quote Ranjha123 said: View Post
    excel ki short key sekhna ka leya koi link bta sakta ha online ho
    Please visit this link : http://www.itdunya.com/forumdisplay....rse-From-Zaara

  13. #12
    seven86's Avatar
    seven86 is offline Advance Member
    Last Online
    25th April 2017 @ 06:12 PM
    Join Date
    27 Nov 2008
    Location
    Karachi
    Gender
    Male
    Posts
    1,964
    Threads
    48
    Credits
    241
    Thanked
    65

    Default

    Quote SajjadKhan84 said: View Post
    Aap ne updated file check kee ??
    Thanks Brother....
    Good work...

    Sorry for late reply....

Page 1 of 2 12 LastLast

Similar Threads

  1. MS EXCEL - Al-Quran in Excel
    By Mubashir Aziz in forum General Discussion
    Replies: 45
    Last Post: 16th March 2015, 08:59 PM
  2. Not Working Zaara's Excel Tutorial In Pdf & 300 Excel Tips
    By iftikhar01 in forum General Discussion
    Replies: 94
    Last Post: 14th May 2012, 04: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
  •