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

Thread: Farmula

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

    Default

    Rate list ka formula required hai???

  2. #14
    KingKhan84's Avatar
    KingKhan84 is offline Advance Member
    Last Online
    4th January 2018 @ 11:22 AM
    Join Date
    08 Mar 2017
    Gender
    Male
    Posts
    1,138
    Threads
    47
    Credits
    6,827
    Thanked
    63

    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
    4th January 2018 @ 11:22 AM
    Join Date
    08 Mar 2017
    Gender
    Male
    Posts
    1,138
    Threads
    47
    Credits
    6,827
    Thanked
    63

    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 @ 06: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 @ 02: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
    16th February 2018 @ 08:36 AM
    Join Date
    06 Jun 2017
    Location
    Faisalabad
    Age
    22
    Gender
    Male
    Posts
    26
    Threads
    2
    Credits
    208
    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
    14,308
    Threads
    273
    Credits
    60,737
    Thanked
    788

    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
    6th February 2018 @ 11:36 AM
    Join Date
    17 Aug 2017
    Location
    Azad kashmir
    Gender
    Male
    Posts
    28
    Threads
    20
    Credits
    337
    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

  9. #21
    Join Date
    19 Oct 2017
    Location
    Multan
    Gender
    Male
    Posts
    59
    Threads
    7
    Credits
    546
    Thanked
    2

    Thumbs up

    File with formula attached below....

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

  10. #22
    ihsanellahi is offline Senior Member+
    Last Online
    Today @ 12:57 PM
    Join Date
    11 Apr 2009
    Age
    38
    Posts
    60
    Threads
    9
    Credits
    204
    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 December 2017 @ 07:10 PM
    Join Date
    24 Jul 2016
    Age
    25
    Gender
    Male
    Posts
    1
    Threads
    0
    Credits
    191
    Thanked
    0

    Default USE VLOOKUP FORMULA

    USE VLOOKUP FORMULA

  12. #24
    Join Date
    21 Dec 2008
    Location
    Faisalabad
    Age
    35
    Gender
    Male
    Posts
    2,314
    Threads
    103
    Credits
    1,675
    Thanked
    166

    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, 10: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, 01:28 AM
  4. If Farmula in excel
    By sandhu16 in forum Ask an Expert
    Replies: 0
    Last Post: 7th April 2012, 04: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
  •