Results 1 to 8 of 8

Thread: Excel formula chahiye

  1. #1
    alim khan's Avatar
    alim khan is offline Senior Member+
    Last Online
    9th July 2018 @ 10:36 PM
    Join Date
    22 May 2009
    Age
    46
    Posts
    221
    Threads
    82
    Credits
    1,065
    Thanked
    7

    Question Excel formula chahiye



    experts mujhe excel ki ek master sheet taiyar karni hai pls meri madad karen.
    sheet mein maine bohot si jagah per formula lagaya hai lekin phir bhi file sahi nahi ban rahi hai.pls is ke har cell ko dekhen mujhe jaisa chahiye waisa bana kar den badi mahebani hogi.


    Attached Files Attached Files

  2. #2
    zulfi721's Avatar
    zulfi721 is offline Senior Member+
    Last Online
    4th May 2017 @ 03:41 PM
    Join Date
    05 Mar 2010
    Location
    On Planet earth
    Posts
    926
    Threads
    103
    Credits
    1,104
    Thanked
    66

    Default

    Brother,aap apni requirements btao.....coz sheet main to just sum kiya huwa hy or quantity ka column hy or what is in the column a b c d respectively.........aap kiya krna chahty ho agar ye juldi sy bta do to aap ke sheet abhi complete ho jati hy.............

  3. #3
    alim khan's Avatar
    alim khan is offline Senior Member+
    Last Online
    9th July 2018 @ 10:36 PM
    Join Date
    22 May 2009
    Age
    46
    Posts
    221
    Threads
    82
    Credits
    1,065
    Thanked
    7

    Default

    Quote zulfi721 said: View Post
    Brother,aap apni requirements btao.....coz sheet main to just sum kiya huwa hy or quantity ka column hy or what is in the column a b c d respectively.........aap kiya krna chahty ho agar ye juldi sy bta do to aap ke sheet abhi complete ho jati hy.............


    BHAI A B C MEIN ALAG ALAG BRAND KI KEMAT HAI MUJHE UN MEIN DIFRENCE NIKALNA HAI A MEIN JAB MAI AMOUNT AUR QUNTY(I) KO (*) KARTA HUN TO (J) MEIN ALAG FIGAR AA RAHA HAI.MUJHE JO FIGUR CHAHIYE(L*M=N) WOH MAINE SIDE MEIN DIYA HAI. WAISA HI FIGUR MUJHE (F*I=J) MEIN CHAHIYE.


  4. #4
    zulfi721's Avatar
    zulfi721 is offline Senior Member+
    Last Online
    4th May 2017 @ 03:41 PM
    Join Date
    05 Mar 2010
    Location
    On Planet earth
    Posts
    926
    Threads
    103
    Credits
    1,104
    Thanked
    66

    Default

    Quote alim khan said: View Post


    BHAI A B C MEIN ALAG ALAG BRAND KI KEMAT HAI MUJHE UN MEIN DIFRENCE NIKALNA HAI A MEIN JAB MAI AMOUNT AUR QUNTY(I) KO (*) KARTA HUN TO (J) MEIN ALAG FIGAR AA RAHA HAI.MUJHE JO FIGUR CHAHIYE(L*M=N) WOH MAINE SIDE MEIN DIYA HAI. WAISA HI FIGUR MUJHE (F*I=J) MEIN CHAHIYE.

    bhai aap k amount walay column main jo formula hy usy check karo or percentage wagaira detail main brief kr do........coz problm aap ke simple hy aap bta nahin pa rahy ho

  5. #5
    alim khan's Avatar
    alim khan is offline Senior Member+
    Last Online
    9th July 2018 @ 10:36 PM
    Join Date
    22 May 2009
    Age
    46
    Posts
    221
    Threads
    82
    Credits
    1,065
    Thanked
    7

    Default

    Quote zulfi721 said: View Post


    bhai aap k amount walay column main jo formula hy usy check karo or percentage wagaira detail main brief kr do........coz problm aap ke simple hy aap bta nahin pa rahy ho


    bhai detail men batata hun meri company ek product banati jis ki kimat 99 hai aur uspe hum customer ko 65% discnt. dete hain aur extra 2% bhi aid karte hain.jo product 99 ka hai woh customer ko 65% discount dene per 35 mein aata hai( 2% chhod kar) ab agar customer mujh se 10 quantity leta hai to uski kimat 35 aani chahiye lekin wahan per 347 aa rahi hai.to aisa koi formula batao ko jo 35 show ho raha hai mujhe usi se 10 quantity * honi chahiye. a b c d jo maine banaya hai woh alag alag companys ke products hain same hamari tarah.mai dusri company aur apni company ke rate ka difrence nikalna chahta hun.isiliye mai ye master sheet banani hai.
    pls help me.



  6. #6
    zulfi721's Avatar
    zulfi721 is offline Senior Member+
    Last Online
    4th May 2017 @ 03:41 PM
    Join Date
    05 Mar 2010
    Location
    On Planet earth
    Posts
    926
    Threads
    103
    Credits
    1,104
    Thanked
    66

    Default

    bhai aap ye 2% nikal k is ka kya krty ho....customer kiya mazeed 2%discount daity ho ya kuch or hy......aap bech main ye b consider kr rahy ho or DSP?kiya hy ye b btao.....

  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

    Asal mein Sheet A kay column F (amount) mein jo value hay woh 34.65 hay, per aap nay Cell format ko Number set kia hova hay iss liyay 35 dikh raha hay, tabhi aap ka NET 34.65*10=346.5=347 nazar aa raha hay. Jab keh aap chah rahay hain keh NET column mein : 35*10=350 nazar ayay.

    Aap column F (amount) mein yeh formula likhain:
    =ROUND(D4-(D4*E4)/100,0)

    sahi ho jayay ga

  8. #8
    alim khan's Avatar
    alim khan is offline Senior Member+
    Last Online
    9th July 2018 @ 10:36 PM
    Join Date
    22 May 2009
    Age
    46
    Posts
    221
    Threads
    82
    Credits
    1,065
    Thanked
    7

    Thumbs up thanks

    Quote sayhellotoit said: View Post
    Asal mein Sheet A kay column F (amount) mein jo value hay woh 34.65 hay, per aap nay Cell format ko Number set kia hova hay iss liyay 35 dikh raha hay, tabhi aap ka NET 34.65*10=346.5=347 nazar aa raha hay. Jab keh aap chah rahay hain keh NET column mein : 35*10=350 nazar ayay.

    Aap column F (amount) mein yeh formula likhain:
    =ROUND(D4-(D4*E4)/100,0)

    sahi ho jayay ga



    bhai shukriya aap ne sahi formula bataya.mera masla hal ho gaya.


    thanks a lot.




    problem solve CLOSE THE THREAD
    Last edited by alim khan; 13th June 2010 at 11:08 PM.

Similar Threads

  1. Solved Excel ka aik formula chahiye..Plz Help me
    By umair.khokhar in forum Solved Problems (IT)
    Replies: 12
    Last Post: 16th April 2012, 09:42 PM
  2. Excel Formula chahiye..Plz
    By Crime Master in forum Ask an Expert
    Replies: 8
    Last Post: 2nd July 2011, 01:38 PM
  3. Excel formula chahiye
    By alim khan in forum Ask an Expert
    Replies: 12
    Last Post: 6th June 2010, 12:30 AM
  4. Excel formula chahiye
    By alim khan in forum Solved Problems (IT)
    Replies: 4
    Last Post: 5th June 2010, 12:54 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
  •