Results 1 to 8 of 8

Thread: plz helpme brother urgent help.

  1. #1
    armughan is offline Junior Member
    Last Online
    15th September 2013 @ 12:41 PM
    Join Date
    14 Aug 2006
    Posts
    15
    Threads
    8
    Credits
    0
    Thanked
    0

    Default plz helpme brother urgent help.

    Salam

    How r u brothers & sisters

    I hope u will b fine

    Sir mujhay excel kay mutaliq 2 question poochnay they wo yeh hain . plz app zarror anser dena bcozmujhay bohat zarrorat hain un kay answer ka.plz brother.

    1. Sir mera pehla question yeh hain kay main chata hoon kay agar koi aisa formula bataday kay agar suppose karien kay Cell A1 main ek value 500 likhi hain & Cell A2 main bhi ek value 300 likhi hain , to main chata hoon kay koi aisa formula ho kay agar main Cell A1 ko Cell A2 say minus(-) karoo to answer Cell B1 main jaye . or agar Cell A1 main value 300 likhi hain and Cell A2 main value 500 likhi hain to agar main Cell A1 ko Cell A2 say minus(-) karoo to answer Cell B2 main jaye.

    2. Mera doosra question yeh hain kay main chata hoon kay koi aisa formula ho kay agar ek person ki income one Lac (100000) hain to iss per koi tax nahin hain .laykin agar kisi person ki income one Lac One rupees (100001) say Three Lac (300000) tak hain to uss per 7.5% tax deduct ho yani katay. And agar income Three Lac (300000) say four Lac (400000) hain to uss per 12.5% tax deduct ho yani itna percent tax katay.

    Ok brother I wait your good answer. Plz brother zaroor answer dana app ki mehar bani hogi

  2. #2
    Sheeda_Pastol's Avatar
    Sheeda_Pastol is offline Senior Member+
    Last Online
    28th November 2010 @ 11:46 AM
    Join Date
    21 Dec 2005
    Location
    IRIS ga mo im nika ?
    Posts
    16,800
    Threads
    125
    Credits
    990
    Thanked
    344

    Default

    Quote armughan said:
    1. Sir mera pehla question yeh hain kay main chata hoon kay agar koi aisa formula bataday kay agar suppose karien kay Cell A1 main ek value 500 likhi hain & Cell A2 main bhi ek value 300 likhi hain , to main chata hoon kay koi aisa formula ho kay agar main Cell A1 ko Cell A2 say minus(-) karoo to answer Cell B1 main jaye . or agar Cell A1 main value 300 likhi hain and Cell A2 main value 500 likhi hain to agar main Cell A1 ko Cell A2 say minus(-) karoo to answer Cell B2 main jaye.
    Aap cell B1 main yeh formula likhain
    =IF(A1-A2>0,A1-A2," ")

    aur cell B2 main yeh formula likhain
    =IF(A1-A2<0,A1-A2," ")

    is tarah agar A1-A2 agar minus main hay yani less than zero hay to B1 main jaye gi warna B2 main jaye gi.

    Quote armughan said:
    2. Mera doosra question yeh hain kay main chata hoon kay koi aisa formula ho kay agar ek person ki income one Lac (100000) hain to iss per koi tax nahin hain .laykin agar kisi person ki income one Lac One rupees (100001) say Three Lac (300000) tak hain to uss per 7.5% tax deduct ho yani katay. And agar income Three Lac (300000) say four Lac (400000) hain to uss per 12.5% tax deduct ho yani itna percent tax katay.
    Aap cell A1 main income likhain aur phir B1 main hum us par tax calcualte karain gain aur C1 main us ki income after tax deduction

    A1 main income likhnay kay baad B1 main tax ka yeh formula likhain
    =IF(A1>300000,12.5,IF(A1>100000,7.5,0))

    is forumalay B1say 100000 tak koi tax naheen, 100001 say 300000 tak 7.5 aur 300001 say above par 12.5 value ajaye gi

    Ab C1 main yeh forumla likhain
    =A1-(A1*B1/100)

    is forumlay say C1 main salary after tax deduction kay ajaye gi.


    Agar koi masla ho to pooch lejiaye ga

  3. #3
    mr_obaid's Avatar
    mr_obaid is offline Senior Member+
    Last Online
    18th December 2011 @ 03:20 AM
    Join Date
    07 Jul 2006
    Location
    karachi THE light
    Posts
    2,139
    Threads
    114
    Credits
    0
    Thanked
    0

    Default

    nice work shida jee
    farooq-o-hassan ka ranj hum kcuh kam nahi kartay,,
    haan mager sina-o-sir peet kar matam nahi kartay,,,
    kafir hain jo munkar hain hayyat-ush-shoda kay,,,
    hum zinda logo per matam nahi kartay.....

  4. #4
    Join Date
    05 Jul 2006
    Location
    Karachi
    Age
    35
    Posts
    1,726
    Threads
    198
    Credits
    950
    Thanked
    0

    Default

    Assalam O Alaikum !
    Sheeda Pistol Jee Well Come Bohot Arsey Bad
    Ab Maza Aye Ga App Hamarey Membaran Ki Har Momkin Help Karaingey
    Thanks Sheeda Bhai
    Wish U All The Best
    Apna Khayal Rakhna
    Allah Haffiz

  5. #5
    arshy's Avatar
    arshy is offline Senior Member+
    Last Online
    4th November 2014 @ 07:09 PM
    Join Date
    15 Mar 2006
    Location
    Europe
    Posts
    925
    Threads
    48
    Credits
    0
    Thanked
    3

    Thumbs up

    Well Come Sheeda Bhai ,kahan Thay Ap ? Itdunya Nay Ap Ko Bahot Miss Kiya.

  6. #6
    Sheeda_Pastol's Avatar
    Sheeda_Pastol is offline Senior Member+
    Last Online
    28th November 2010 @ 11:46 AM
    Join Date
    21 Dec 2005
    Location
    IRIS ga mo im nika ?
    Posts
    16,800
    Threads
    125
    Credits
    990
    Thanked
    344

    Default

    dear mr_obaid, jaan_leva aur arshi jee, aap logo kay khulus ka bohot bohot shukria. main guzishta dino kaafi masroof tha magar ab normal hay.

    bohot bohot shukria

  7. #7
    armughan is offline Junior Member
    Last Online
    15th September 2013 @ 12:41 PM
    Join Date
    14 Aug 2006
    Posts
    15
    Threads
    8
    Credits
    0
    Thanked
    0

    Default thanks

    brother app ki bohat meharbani kay app nay answer diya thanks

  8. #8
    Sheeda_Pastol's Avatar
    Sheeda_Pastol is offline Senior Member+
    Last Online
    28th November 2010 @ 11:46 AM
    Join Date
    21 Dec 2005
    Location
    IRIS ga mo im nika ?
    Posts
    16,800
    Threads
    125
    Credits
    990
    Thanked
    344

    Default

    armughan bhai aap ka kaam hogaya hamain khushi. bus isi tarah is forum par atay rahain

Similar Threads

  1. My All Brother Help Me.........urgent
    By sfjiii in forum Ask an Expert
    Replies: 5
    Last Post: 16th August 2011, 06:50 PM
  2. urgent helpme
    By creative_eyes in forum Ask an Expert
    Replies: 1
    Last Post: 10th November 2009, 01:30 AM
  3. plz helpme urgent
    By Jumb006 in forum Ask an Expert
    Replies: 11
    Last Post: 25th January 2009, 07:24 PM
  4. plz urgent helpme plz urgent bhai
    By armughan in forum Ask an Expert
    Replies: 2
    Last Post: 13th October 2006, 03:20 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
  •