Page 2 of 3 FirstFirst 123 LastLast
Results 13 to 24 of 28

Thread: Farmula

  1. #13
    Join Date
    03 Feb 2010
    Location
    Multan
    Age
    36
    Posts
    47
    Threads
    1
    Credits
    81
    Thanked
    0

    Default

    Rate list ka formula required hai???

  2. #14
    KingKhan84's Avatar
    KingKhan84 is offline Advance Member
    Last Online
    23rd August 2023 @ 03:59 PM
    Join Date
    08 Mar 2017
    Gender
    Male
    Posts
    1,814
    Threads
    73
    Credits
    11,419
    Thanked
    79

    Default

    Quote pari gull said: View Post
    Ma screen shot kasy do .. Ma PC pa kam kr rahi hun ..
    Please update sample file....
    Desert Rose
    A Simple Person With Complicated Mind

  3. #15
    KingKhan84's Avatar
    KingKhan84 is offline Advance Member
    Last Online
    23rd August 2023 @ 03:59 PM
    Join Date
    08 Mar 2017
    Gender
    Male
    Posts
    1,814
    Threads
    73
    Credits
    11,419
    Thanked
    79

    Default

    Quote Shahbazjee7 said: View Post
    Rate list ka formula required hai???
    Sir thori si information de den... apke madad koshesh karainge or InshaALLAH kardi jayegi

  4. #16
    afzal.seemab is offline Junior Member
    Last Online
    7th June 2017 @ 05:05 PM
    Join Date
    07 Jun 2017
    Age
    76
    Gender
    Male
    Posts
    1
    Threads
    0
    Credits
    5
    Thanked
    0

    Default Solution

    Quote pari gull said: View Post
    Plz mja koi ASA farmula bta sakta a k ma bus city k nam lekho or us Ki value us k samny ay .. Plz any one help me....
    =IF(B9="lahore",30,IF(B9="islamabad",49,IF(B9="kar achi",40))) B9 IS CITY FIELD ID


  5. #17
    WardaRiaz is offline Senior Member+
    Last Online
    12th September 2017 @ 01:23 PM
    Join Date
    12 Jun 2017
    Location
    Karachi
    Gender
    Female
    Posts
    59
    Threads
    1
    Credits
    394
    Thanked
    2

    Default

    Hey Pari,

    You can use vlookup farmula here:

    Syntax

    The syntax for the VLOOKUP function in Microsoft Excel is:

    =VLOOKUP( value, table, index_number, [approximate_match] )

    Parameters or Arguments

    value
    The value to search for in the first column of the table.
    table
    Two or more columns of data that is sorted in ascending order.
    index_number
    The column number in table from which the matching value must be returned. The first column is 1.
    approximate_match
    Optional. Enter FALSE to find an exact match. Enter TRUE to find an approximate match. If this parameter is omitted, TRUE is the default.

    If you still can't understand it you can search the use of this formula in YouTube.

  6. #18
    sam4you is offline Senior Member+
    Last Online
    20th February 2021 @ 09:21 PM
    Join Date
    06 Jun 2017
    Location
    Faisalabad
    Age
    28
    Gender
    Male
    Posts
    65
    Threads
    13
    Credits
    422
    Thanked
    2

    Default

    je han ye possible hai

    lookup k formula k zariye

  7. #19
    Baazigar's Avatar
    Baazigar is offline V.I.P
    Last Online
    17th March 2024 @ 08:40 PM
    Join Date
    16 Aug 2009
    Location
    Makkah , Saudia
    Gender
    Male
    Posts
    29,907
    Threads
    482
    Credits
    148,884
    Thanked
    970

    Default

    Quote WardaRiaz said: View Post
    Hey Pari,

    You can use vlookup farmula here:

    Syntax

    The syntax for the VLOOKUP function in Microsoft Excel is:

    =VLOOKUP( value, table, index_number, [approximate_match] )

    Parameters or Arguments

    value
    The value to search for in the first column of the table.
    table
    Two or more columns of data that is sorted in ascending order.
    index_number
    The column number in table from which the matching value must be returned. The first column is 1.
    approximate_match
    Optional. Enter FALSE to find an exact match. Enter TRUE to find an approximate match. If this parameter is omitted, TRUE is the default.

    If you still can't understand it you can search the use of this formula in YouTube.
    Well Explained

  8. #20
    Abdul Quddoos is offline Junior Member
    Last Online
    20th September 2020 @ 12:32 PM
    Join Date
    17 Aug 2017
    Location
    Azad kashmir
    Gender
    Male
    Posts
    28
    Threads
    20
    Credits
    386
    Thanked
    3

    Default

    yes madam ap screen shot dain shayed ma ap ke koi help kar don ma be excel use karta ho liken bohat kam

  9. #21
    Join Date
    19 Oct 2017
    Location
    Multan
    Gender
    Male
    Posts
    60
    Threads
    8
    Thanked
    2

    Thumbs up

    File with formula attached below....

    Enjoy.........
    Attached Files Attached Files

  10. #22
    ihsanellahi is offline Senior Member+
    Last Online
    12th November 2022 @ 02:02 AM
    Join Date
    11 Apr 2009
    Age
    44
    Posts
    60
    Threads
    9
    Credits
    255
    Thanked
    0

    Default

    mere khayal se app ka kaam nahi ho ga kion k app ko kuch to khod se add karna ho ga or farmula b kafi bhara lagana pare ga jesa k malti ^>mto +34= wagera wala

  11. #23
    salman.alraya is offline Junior Member
    Last Online
    28th July 2022 @ 12:30 PM
    Join Date
    24 Jul 2016
    Age
    31
    Gender
    Male
    Posts
    1
    Threads
    0
    Credits
    1,064
    Thanked
    0

    Default USE VLOOKUP FORMULA

    USE VLOOKUP FORMULA

  12. #24
    Join Date
    21 Dec 2008
    Location
    Faisalabad
    Age
    41
    Gender
    Male
    Posts
    2,581
    Threads
    104
    Credits
    4,262
    Thanked
    173

    Default

    see attached file

    Quote pari gull said: View Post
    Plz mja koi ASA farmula bta sakta a k ma bus city k nam lekho or us Ki value us k samny ay .. Plz any one help me....

Page 2 of 3 FirstFirst 123 LastLast

Similar Threads

  1. Vlookup Farmula
    By faiz4allz in forum Ask an Expert
    Replies: 1
    Last Post: 1st April 2014, 09:06 AM
  2. Need Farmula
    By DaniShah786 in forum Educational Help
    Replies: 2
    Last Post: 6th March 2013, 08:07 PM
  3. Solved Excel Farmula Help
    By Shireen Shari in forum Solved Problems (IT)
    Replies: 15
    Last Post: 21st April 2012, 12:28 AM
  4. If Farmula in excel
    By sandhu16 in forum Ask an Expert
    Replies: 0
    Last Post: 7th April 2012, 03:03 PM
  5. Excel farmula Help
    By Shireen Shari in forum Ask an Expert
    Replies: 3
    Last Post: 6th February 2012, 03: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
  •