Page 1 of 2 12 LastLast
Results 1 to 12 of 13

Thread: Excel Formula Help

  1. #1
    umerali10's Avatar
    umerali10 is offline Senior Member+
    Last Online
    19th October 2018 @ 03:36 PM
    Join Date
    14 Apr 2009
    Location
    Rawalpindi
    Age
    36
    Gender
    Male
    Posts
    471
    Threads
    49
    Credits
    689
    Thanked
    83

    Default Excel Formula Help

    Screenshot me dekhein muje aisa formula required he
    Attached Images Attached Images  

  2. #2
    GreatKhan1's Avatar
    GreatKhan1 is offline Senior Member+
    Last Online
    17th December 2016 @ 04:27 PM
    Join Date
    16 Dec 2011
    Location
    Pakistan
    Gender
    Male
    Posts
    797
    Threads
    170
    Credits
    206
    Thanked
    35

    Default

    kaisa screen shot????????

  3. #3
    Farhan213 is offline Senior Member+
    Last Online
    22nd October 2015 @ 10:09 PM
    Join Date
    21 Sep 2007
    Age
    34
    Posts
    1,525
    Threads
    81
    Credits
    0
    Thanked
    77

    Default

    Pheley Salam phir kalam
    Janaab jab tak aap formula complete enter nahi kardeytey ..!
    tab tak to aap screen short basani sey leysaktey hain...

  4. #4
    umerali10's Avatar
    umerali10 is offline Senior Member+
    Last Online
    19th October 2018 @ 03:36 PM
    Join Date
    14 Apr 2009
    Location
    Rawalpindi
    Age
    36
    Gender
    Male
    Posts
    471
    Threads
    49
    Credits
    689
    Thanked
    83

    Default

    screenshot upload kr dia he

  5. #5
    syar is offline Advance Member
    Last Online
    14th March 2024 @ 07:49 PM
    Join Date
    31 Jul 2009
    Location
    Nowshera(KP)
    Age
    47
    Gender
    Male
    Posts
    882
    Threads
    9
    Credits
    548
    Thanked
    340

    Default

    salam::

    in F2
    Code:
    =IF(G2="p","Payable","")
    regards

  6. #6
    rizwanmalik2 is offline Senior Member+
    Last Online
    7th July 2016 @ 05:55 AM
    Join Date
    31 Oct 2012
    Location
    Shahdra Lahore
    Gender
    Male
    Posts
    59
    Threads
    0
    Credits
    995
    Thanked
    2

    Default

    Dosto agar Uper walay block me koi word likha hua ho to usko nichay walay block me likhnay ki short cut key kya hai??

  7. #7
    Farhan213 is offline Senior Member+
    Last Online
    22nd October 2015 @ 10:09 PM
    Join Date
    21 Sep 2007
    Age
    34
    Posts
    1,525
    Threads
    81
    Credits
    0
    Thanked
    77

    Default

    Walaikom Mussalam...
    Janaab aisi koi shortcut key nahi hai..
    excel mein auto save hota hai. .aap bus ney agr koi word pheley sey type kia hai to.. woh aap ko dubara likhney ki zaroorat nahi parti bus aap chand alfaz likhdein excel khud aapsey puchey ga. agar aap enter kardeygey to write wahi word aajaye gaa. agar aap aghey bhar jayein gey to skip kardeyga..
    aur agar kissi particular colum mein value paste karwani hai to . syar ko follow kijiye..

    Remember: Pheley Salam phir kalam..

  8. #8
    syar is offline Advance Member
    Last Online
    14th March 2024 @ 07:49 PM
    Join Date
    31 Jul 2009
    Location
    Nowshera(KP)
    Age
    47
    Gender
    Male
    Posts
    882
    Threads
    9
    Credits
    548
    Thanked
    340

    Default

    Quote rizwanmalik2 said: View Post
    Dosto agar Uper walay block me koi word likha hua ho to usko nichay walay block me likhnay ki short cut key kya hai??
    may be i under stand corret.
    for example agar aap na A1 m xyz lekha ha aur chahte hain k B1 m ya auto copy ho jae ya khod bakhod aa jae tu

    Code:
    CTRL+"
    press karain oper wale cell m jo kuch lekha ho wohe ise cell m aa jae ga. chahe wo forumal ho ya kuch bhe ho.

    regards

  9. #9
    IT.BOY's Avatar
    IT.BOY is offline Senior Member
    Last Online
    17th November 2017 @ 12:13 PM
    Join Date
    26 Dec 2007
    Location
    *MAA KI AGOOSH*
    Gender
    Male
    Posts
    28,374
    Threads
    651
    Credits
    998
    Thanked
    3079

    Default

    Quote syar said: View Post
    salam::

    In f2
    Code:
    =if(g2="p","payable","")
    regards
    ویری نائس دوست۔۔۔
    [FONT="Jameel Noori Nastaleeq"][CENTER][COLOR="Blue"][SIZE="5"][B]Coming Soon...:)[/B][/SIZE][/COLOR][/CENTER][/FONT]

  10. #10
    umerali10's Avatar
    umerali10 is offline Senior Member+
    Last Online
    19th October 2018 @ 03:36 PM
    Join Date
    14 Apr 2009
    Location
    Rawalpindi
    Age
    36
    Gender
    Male
    Posts
    471
    Threads
    49
    Credits
    689
    Thanked
    83

    Default

    salam::

    in F2
    Code:
    =IF(G2="p","Payable","")
    regards
    nice bhai or ager hum ne ye krna ho ko p type krne pe payable or r type krne pe recieved or c typ krne per clear aye to?? kia formula ho ga

  11. #11
    JAM ZEESHAN's Avatar
    JAM ZEESHAN is offline Senior Member+
    Last Online
    6th November 2016 @ 02:09 AM
    Join Date
    29 Nov 2010
    Location
    <<<<<<Islamabad>>>>>>>
    Gender
    Male
    Posts
    1,072
    Threads
    195
    Credits
    5
    Thanked
    68

    Default

    very nice
    live Others......................

  12. #12
    syar is offline Advance Member
    Last Online
    14th March 2024 @ 07:49 PM
    Join Date
    31 Jul 2009
    Location
    Nowshera(KP)
    Age
    47
    Gender
    Male
    Posts
    882
    Threads
    9
    Credits
    548
    Thanked
    340

    Default

    Quote umerali10 said: View Post
    nice bhai or ager hum ne ye krna ho ko p type krne pe payable or r type krne pe recieved or c typ krne per clear aye to?? kia formula ho ga
    Aap nested if k bhe use kar sakte hain lekan personally I prefer LOOKUP on nested if

    in F2
    Code:
    =LOOKUP(G2,{"p","c","r"},{"Payable","Credit",""})
    regards,

Page 1 of 2 12 LastLast

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. Solved Excel Formula
    By Qutab in forum Solved Problems (IT)
    Replies: 10
    Last Post: 26th January 2012, 08:48 PM
  3. What is Excel Formula for Difference in Two Values ?
    By Baazigar in forum Ask an Expert
    Replies: 2
    Last Post: 30th May 2011, 09:45 PM
  4. Excel main Less Than ka Formula?
    By flower_toyou8 in forum Solved Problems (IT)
    Replies: 19
    Last Post: 22nd July 2010, 04:27 PM
  5. excel formula need
    By alim khan in forum Ask an Expert
    Replies: 6
    Last Post: 11th April 2010, 10:31 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
  •