Results 1 to 7 of 7

Thread: excel formula need

  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
    47
    Posts
    221
    Threads
    82
    Credits
    1,065
    Thanked
    7

    Default excel formula need



    bhaiyon mujhe excel mein ek formula chahiye jis ke zarye percentage nikala jata hai.


    jaise agar kisi cheez ki kimat 99hai aur usper discount 65% hai to yeh excel mein kaise nikala jaye


    99/65%= is ka formula chahiye.



  2. #2
    itmunda is offline Member
    Last Online
    5th August 2010 @ 01:26 PM
    Join Date
    16 Mar 2010
    Age
    33
    Posts
    119
    Threads
    12
    Thanked
    5

    Default

    Bhai this called average

    =average(colum+row:colum+row)

  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

    Quote itmunda said: View Post
    Bhai this called average

    =average(colum+row:colum+row)
    Bhai agar nahi pata tu galat mashwara kion daitay ho.
    Woh discount ka pooch raha hay aur aap average ka bata rahay ho.

  4. #4
    raz24726's Avatar
    raz24726 is offline Advance Member
    Last Online
    Yesterday @ 08:05 PM
    Join Date
    16 Dec 2009
    Location
    Agr Milu To Muj
    Gender
    Male
    Posts
    5,502
    Threads
    79
    Credits
    1,178
    Thanked
    432

    Default

    dear =range/range or =range/25%

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

    Kia iss tarha pooch rahay hain bhai?
    =Price-Price*percent_discount

  6. #6
    habibrahet's Avatar
    habibrahet is offline Advance Member
    Last Online
    25th August 2021 @ 02:33 PM
    Join Date
    30 Nov 2008
    Location
    PaKisTaN
    Gender
    Male
    Posts
    2,041
    Threads
    140
    Credits
    69
    Thanked
    102

    Default

    Column B main Sale Price enter keejiay

    Aor

    ager discount (65%) fixed hay her item per (ya her rate per) to yeh formula likhiay
    =B2-(B2*0.65)

    ya jitni zyada sale ussi munasbat say discount to phir B Colum main price (or Sale) likhiay, C Colume main Discount (sale ki munasibat say, jitnay percent discount dena hay) woh enter keejiay or screen shot main diya gaya formula enter kar deejiay, Target Cell main.
    Attached Images Attached Images  
    The Race Is Not Over, Coz I've Not Won Yet.



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

    Default


    sabhi bhaiyon ka bohot bohot shukriya.


Similar Threads

  1. Excel tip (Hidde formula in formula bar in excel)
    By Honour12 in forum Urdu Tutorials & Designing
    Replies: 14
    Last Post: 31st May 2016, 10:06 AM
  2. Excel formula
    By naeemshahzad in forum Ask an Expert
    Replies: 0
    Last Post: 22nd March 2015, 12:22 PM
  3. Excel Formula Help
    By adnanmomin in forum Ask an Expert
    Replies: 4
    Last Post: 31st May 2013, 06:38 PM
  4. help a Excel formula
    By Ameen Asim in forum Ask an Expert
    Replies: 0
    Last Post: 6th May 2012, 04:08 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
  •