Page 2 of 2 FirstFirst 12
Results 13 to 20 of 20

Thread: Farmula

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

    Default

    Rate list ka formula required hai???

  2. #14
    SajjadKhan84's Avatar
    SajjadKhan84 is offline Advance Member
    Last Online
    Yesterday @ 03:46 PM
    Join Date
    08 Mar 2017
    Gender
    Male
    Posts
    1,047
    Threads
    43
    Credits
    6,493
    Thanked
    60

    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
    SajjadKhan84's Avatar
    SajjadKhan84 is offline Advance Member
    Last Online
    Yesterday @ 03:46 PM
    Join Date
    08 Mar 2017
    Gender
    Male
    Posts
    1,047
    Threads
    43
    Credits
    6,493
    Thanked
    60

    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
    70
    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 Junior Member
    Last Online
    17th September 2017 @ 06:44 PM
    Join Date
    06 Jun 2017
    Location
    Faisalabad
    Age
    21
    Gender
    Male
    Posts
    23
    Threads
    2
    Credits
    194
    Thanked: 1

    Default

    je han ye possible hai

    lookup k formula k zariye

  7. #19
    Join Date
    16 Aug 2009
    Location
    Makkah , Saudia
    Gender
    Male
    Posts
    13,167
    Threads
    269
    Credits
    54,399
    Thanked
    749

    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
    19th September 2017 @ 02:48 PM
    Join Date
    17 Aug 2017
    Location
    Azad kashmir
    Gender
    Male
    Posts
    25
    Threads
    20
    Credits
    320
    Thanked
    2

    Default

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

Page 2 of 2 FirstFirst 12

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, 07: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, 02: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
  •