Results 1 to 4 of 4

Thread: Formula in Excel

  1. #1
    Rizwan Anjum's Avatar
    Rizwan Anjum is offline Advance Member
    Last Online
    14th April 2023 @ 12:48 PM
    Join Date
    13 Oct 2012
    Location
    Faisalabad
    Gender
    Male
    Posts
    1,278
    Threads
    375
    Credits
    307
    Thanked
    153

    Default Formula in Excel

    Dear Experts,
    main ek sheet attach kr raha ho us mein agar main Gross amount likho to Tax and Net Amount calculate ho jati hai, lakin mian chahta hon k agar main net amount likho to tax and gross amount calculate ho jay.
    Means k
    1: Gross Amount Likho to Tax and Net Amount Calculate ho.
    2: Net Amount Likho to Tax and Gross Amount Calculate ho.

  2. #2
    Rizwan Anjum's Avatar
    Rizwan Anjum is offline Advance Member
    Last Online
    14th April 2023 @ 12:48 PM
    Join Date
    13 Oct 2012
    Location
    Faisalabad
    Gender
    Male
    Posts
    1,278
    Threads
    375
    Credits
    307
    Thanked
    153

    Default

    Reply me...
    Attached Files Attached Files

  3. #3
    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 Rizwan Anjum said: View Post
    Reply me...
    Umeed hai koi expert apke help jald he kar lega... Lekin Mere bhai zara logic ko samjho

    Case 1 : aap ke pass 1000 rs the jis mai se 20% tax laga (rs.200) aur total apke pass net amont 800 rs reh gaye....

    Ab ager ap kehte ho ke mai 800 rs likho or mere pass total 1000 rs aye to 800 rs ka 20% 160 Rs banta hai aur total 960 ayga....
    So kuch predifine values apko likhni paregi jab he apke pass result thek se ayga.
    Desert Rose
    A Simple Person With Complicated Mind

  4. #4
    Rizwan Anjum's Avatar
    Rizwan Anjum is offline Advance Member
    Last Online
    14th April 2023 @ 12:48 PM
    Join Date
    13 Oct 2012
    Location
    Faisalabad
    Gender
    Male
    Posts
    1,278
    Threads
    375
    Credits
    307
    Thanked
    153

    Default

    Mujhe Predefine % ko krna ha

Similar Threads

  1. Excel help if formula plz help
    By sufyan gee in forum Ask an Expert
    Replies: 7
    Last Post: 23rd September 2018, 06:47 PM
  2. Help Me (Excel Formula)
    By sfahad13 in forum Ask an Expert
    Replies: 1
    Last Post: 2nd December 2017, 10:15 AM
  3. 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
  4. Solved Excel formula
    By masadijaz in forum Solved Problems (IT)
    Replies: 8
    Last Post: 15th July 2011, 10:39 AM
  5. excel formula ??
    By adnanbahrian in forum Ask an Expert
    Replies: 5
    Last Post: 22nd February 2009, 11:06 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
  •