Results 1 to 10 of 10

Thread: Dear Excel Expert Ab To Help Kado

  1. #1
    Rehman shar's Avatar
    Rehman shar is offline Advance Member
    Last Online
    3rd September 2022 @ 06:32 PM
    Join Date
    22 Feb 2012
    Location
    MirPur Khas
    Age
    32
    Gender
    Male
    Posts
    765
    Threads
    68
    Credits
    1,011
    Thanked
    47

    Question Dear Excel Expert Ab To Help Kado

    Dear Dosto Mene Apne Hisaab Se Ab Sahi Tarah se Masla Bayan Kar Diya hai Plz Ap zara Attechment Ko Ghor Se Parh k Problem Solve Kardo..
    Attached Images Attached Images  

  2. #2
    Desert-Rose is offline Member
    Last Online
    17th December 2015 @ 05:43 PM
    Join Date
    13 Feb 2009
    Location
    Karachi
    Gender
    Male
    Posts
    1,751
    Threads
    41
    Thanked
    110

    Default

    Net weight mai ye formula lagaye =A2-B2
    Monds mai ye formula lagao =C2/40
    dosri baat ye batwo ke MONDS ager 44 hai to ospe allownce 44 kese hai (as mention inyour screenshot)

    Further request you to please upload/attache the excel file I will set in 10 mints InshaALLAH

  3. #3
    Rehman shar's Avatar
    Rehman shar is offline Advance Member
    Last Online
    3rd September 2022 @ 06:32 PM
    Join Date
    22 Feb 2012
    Location
    MirPur Khas
    Age
    32
    Gender
    Male
    Posts
    765
    Threads
    68
    Credits
    1,011
    Thanked
    47

    Default

    Bhai Bataya to hai k Per Mond 1 kg Allounce hai is Liye Jitne Monds honge utne Kg Allounce jae ga na

  4. #4
    Rehman shar's Avatar
    Rehman shar is offline Advance Member
    Last Online
    3rd September 2022 @ 06:32 PM
    Join Date
    22 Feb 2012
    Location
    MirPur Khas
    Age
    32
    Gender
    Male
    Posts
    765
    Threads
    68
    Credits
    1,011
    Thanked
    47

    Default

    Or Yar Ye File Yahan Kese Upload karon Samjh nai aa raha

  5. #5
    Desert-Rose is offline Member
    Last Online
    17th December 2015 @ 05:43 PM
    Join Date
    13 Feb 2009
    Location
    Karachi
    Gender
    Male
    Posts
    1,751
    Threads
    41
    Credits
    0
    Thanked
    110

    Default

    Quote Rehman shar said: View Post
    Bhai Bataya to hai k Per Mond 1 kg Allounce hai is Liye Jitne Monds honge utne Kg Allounce jae ga na
    Aap keh rahe ho C column mai jo net weight hai us se aloownce minus hoke pher net monds bana de
    1760 Kgs - 44 Kgs = 1716 banta hai lekin apne 42.9 likha hai..
    Bhaijan pehle khud to clear ho jawo ke kia karna hai

    Ap aisa karo jo entry apko karni hai ose RED mai likh do aur jo formula ke zariye ayegi osko kisi aur color mai kardo then we will sovle your problem by setting formula (aur atleast FB pe to jawab de dia karo)....

  6. #6
    Desert-Rose is offline Member
    Last Online
    17th December 2015 @ 05:43 PM
    Join Date
    13 Feb 2009
    Location
    Karachi
    Gender
    Male
    Posts
    1,751
    Threads
    41
    Credits
    0
    Thanked
    110

    Default

    Quote Rehman shar said: View Post
    Or Yar Ye File Yahan Kese Upload karon Samjh nai aa raha
    Jese ap image upload kar rahe hai.. ose tarah xls file desktop pe save karke upload kardo

  7. #7
    Desert-Rose is offline Member
    Last Online
    17th December 2015 @ 05:43 PM
    Join Date
    13 Feb 2009
    Location
    Karachi
    Gender
    Male
    Posts
    1,751
    Threads
    41
    Credits
    0
    Thanked
    110

    Default

    Dear Check the attached file COLUMN G nahi samjh aaraha.. further apko furmula sirf copy karke neche row mai paste karne hai aur weight ko manual input karna hai...
    kindly check and reply if still any problem
    Attached Files Attached Files

  8. #8
    Rehman shar's Avatar
    Rehman shar is offline Advance Member
    Last Online
    3rd September 2022 @ 06:32 PM
    Join Date
    22 Feb 2012
    Location
    MirPur Khas
    Age
    32
    Gender
    Male
    Posts
    765
    Threads
    68
    Credits
    1,011
    Thanked
    47

    Default

    Quote Desert-Rose said: View Post
    Dear Check the attached file COLUMN G nahi samjh aaraha.. further apko furmula sirf copy karke neche row mai paste karne hai aur weight ko manual input karna hai...
    kindly check and reply if still any problem
    Sir Ap ka be'had ShukrGuzaar hon k Ap ne Apna Qeemti Time Nikaal k Meri Help ki.. Ap ne Bilkul Sahi Samjha hai Meri Problem ko Or Mujhe mann'Chaha kaam b kar k Diya hai But Sir ab Aik Issue aa raha hai or wo ye k Net MONDS men 10 Likha hai Us ko agar Hum 2150Rate se Multiply karte hain to PRICE kuch yuon banti hai 21500 lekin ap k paas to 21487 Price aa rahi hai

  9. #9
    Desert-Rose is offline Member
    Last Online
    17th December 2015 @ 05:43 PM
    Join Date
    13 Feb 2009
    Location
    Karachi
    Gender
    Male
    Posts
    1,751
    Threads
    41
    Credits
    0
    Thanked
    110

    Default

    Quote Rehman shar said: View Post


    Sir Ap ka be'had ShukrGuzaar hon k Ap ne Apna Qeemti Time Nikaal k Meri Help ki.. Ap ne Bilkul Sahi Samjha hai Meri Problem ko Or Mujhe mann'Chaha kaam b kar k Diya hai But Sir ab Aik Issue aa raha hai or wo ye k Net MONDS men 10 Likha hai Us ko agar Hum 2150Rate se Multiply karte hain to PRICE kuch yuon banti hai 21500 lekin ap k paas to 21487 Price aa rahi hai
    Wo islye hai ke formula ke hisab se row one mai Net mond 42.900 hai second row mai 9.994....

  10. #10
    Desert-Rose is offline Member
    Last Online
    17th December 2015 @ 05:43 PM
    Join Date
    13 Feb 2009
    Location
    Karachi
    Gender
    Male
    Posts
    1,751
    Threads
    41
    Credits
    0
    Thanked
    110

    Default

    Updated file attached...
    Attached Files Attached Files

Similar Threads

  1. dEAR EXPERT PLZ HELP
    By sadiq88 in forum Ask an Expert
    Replies: 5
    Last Post: 17th January 2015, 03:53 PM
  2. dear expert
    By Suriashoukat786 in forum Ask an Expert
    Replies: 15
    Last Post: 24th July 2012, 07:01 PM
  3. plz help me?dear expert.
    By amjad ullah in forum Ask an Expert
    Replies: 2
    Last Post: 15th May 2010, 04:12 PM
  4. dear expert help
    By amjadattari in forum Ask an Expert
    Replies: 7
    Last Post: 18th January 2010, 10:54 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
  •