Comments on: Microsoft Excel formulas with examples

Can Microsoft Excel formulas be easy to learn? Yep! This tutorial explains the very basics of Excel formulas for beginners, with detailed steps on how to write and use them. It also provides a number of advanced formula examples for experienced users. You will be amazed how simple creating formulas in Excel actually is. Continue reading →

Comments page 6. Total comments: 205

  1. can you please send me a formula for the below,
    Credit card outstanding is 1000 usd (for example) he/she have to pay minimum bill 50 USD or 2% whichever is higher. please need your cooperation .

  2. i have a sheet as under:
    A B C
    Vehicle Petrol Diesel
    700 60 0
    800 80 0
    345 0 90
    700 50 0
    800 75 0
    500 0 50
    345 0 80
    700 40

    i want all values of 700
    Vehicle Petrol
    e.g: 700 60
    50
    40
    Please what kind of formula can solve my this problem

    1. Hello, Saqib,

      If your data range is A1:C9, please enter 700 in cell E2, paste the following array formula in the adjacent cell (F2) and press Ctrl + Shift + Enter to complete it:

      =IFERROR(INDEX($B$2:$B$9,SMALL(IF($E$2=$A$2:$A$9,ROW($B$2:$B$9)-1,""),ROW(A1))),"")

      Then copy the formula down along column F to see all the matching values for Vehicle 700.

      You can find more details how to Vlookup to return multiple matches in this blog post.

      Hope this information will be helpful for you.

  3. (2947552.44+10%*0.05%+12%+1)/63.10 formula kese lagau

  4. please create the simplest way how to calculate different calculations!

  5. well ive gotten the needed basics in Excel and congratulate the examples,formula etc,thanks Google.

  6. Pls. help with a detailed example for ^ symbol

  7. Hello,

    can you plz send me a formula for the below:-
    i have purchased Atta 1500 kgs for 5029 persons, scale of atta per man is 0.700 gm, i want to know how many persons are covered from total persons 5029

  8. what is the formula for this in Ms exel "(8.3*10^3)/9"

    1. Please send me 2 example of each other
      1 Multiplication
      2 subtraction
      3 Division
      Plz help me fast please anyone tell me???????

  9. I don't understand anything here

  10. How to count poor grade using count if function

  11. I am working on splitting a track of land into parcels. The track of land has an amount money tied to it. Each parcel will be split from the larger whole based on acres. The money will then be split based on the acres of the parcels. Setting up the excel formulas isn't the problem. I seem to be ending up with more money than I started with. How is that possible? Is this a decimal issue? I end up with about $117 more than the whole started with.

    Thanks, Marissa

  12. I am having trouble figuring this one out. I'm trying to get I34=0 when cell F34=0 but when F34>160 I need it to put what is in Cell H34.

    1. Hello, Carey,

      you need to construct a simple nested IF formula in I34:
      =IF(F34=0,0,IF(F34>160,H34,""))

  13. Could anyone help me write a function or direct me to a resource that I can use to write:
    A1 * (B1 or C1 when B1 or C1 is different from zero or different from 'blank')
    The B1 or C1 values will be attributed from a pull down menu and it will be either B1 or C1)
    Thanks a million!!!

  14. this is vary good formula for us. I understand that.....

  15. Differentiate vividly the difference between The Two type of formulas in ms excel giving two examples

  16. Hello everyone,
    I need help with a formula, I'm trying to come up with a formula that will calculate in the same row two possible different operations.
    For example B5-C5 or B5+D5 calculate the total of ether equation depending if it's a credit or debit. I don't know if I'm making myself clear. TIA

    Due Credit Debit Balance
    $99.27 $87.40 $11.87

  17. how do I add 10% to my price using the formula

    1. Hi Gift,

      The generic formula to increase an amount by percentage is this: = Amount * (1 + %)

      To add 10%, multiply your price by (1+10%) or simply by 1.1. For example, if the price is in cell A1, the formula is =A1*1.1

      For more information and formula examples, please see How to calculate percentage in Excel.

  18. If I want to add C1 & C3 and display the result in C3?

  19. Hi very nice technological and teaching Excel formula simple

  20. I need to know how to: input numbers, each in its own cell.I have a formula which I execute in a cell. I make a PDF file for others to view.
    I want to see the numbers that were used in the formula to be automatically inputted into a written formula.I want this formula to be written out and shown in a cell. This will show viewers the formula with numbers that was used in execution of the formula.
    Hope you can help. Thanks.

  21. please send me vlookup formula and hlookup formula with example

  22. Hello Joseph,
    You can use the countifs function for this.
    =countifs(criteria_range,criteria,criteria_range,criteria)
    =countifs(A1:A10,">=1000",A1:A10,"<=5000")
    Where A1 to A10 is the range with employees salary

  23. I want to get the total employee who has a salary of 1,000 - 5,000(example) how can i formulate it? thanks in advance!!

  24. Very nice formula of excel

    1. Dr sir you hereby requested to please avail me the latest examples for Excel. It was helpful.

  25. very nice teaching

  26. Level 0 If % of marks secured is LESS 40%
    Level 1 If % of marks secured is from 40% to 49.9%
    Level 2 If % of marks secured is from 50% to 59.9%
    Level 3 If % of marks secured is from60% to 69.9%
    Level 4 If % of marks secured is from70% to 79.9%
    Level 5 If % of marks secured is equal to 80% and above

    FOR EX

    PERCENTAGE 75 83 82 41 39
    LEVELS

    LEVELS HAVE TO DISPLAY in levels column

  27. hi. I have had a hard time making formula for the following problem in excel. can someone help?

    please give me the true formula.
    this is the problem.

    if F15 is within 0.26-0.75 and H15 is above 0.20 the value returns to "retained"

    if F15 is within 0.26-0.75 and H15 is below 0.20 the value returns to "revised"

    if F15 is not within 0.26-0.75 and H15 is above 0.20 the value returns to "revised"

    if F15 is not within 0.26-0.75 and H15 is below 0.20 the value returns to "rejected"

    I will be glad to your right response. thank u.

    1. =IF((AND(F15>0.26,F15=0.20)="truetrue","retained",IF((AND(F15>0.26,F15=0.20)="falsefalse","rejected",IF(AND(F15>0.26,F15=0.20)=FALSE,"revised","")))

      1. I swear its glitching. Actual formula keeps changing.

      2. I swear its glitching. Actual formula keeps changing.
        =IF((AND(F15>0.26,F15=0.20)="truetrue","retained",IF((AND(F15>0.26,F15=0.20)="falsefalse","rejected",IF(AND(F15>0.26,F15=0.20)=FALSE,"revised","")))

        1. Formula in the form of a self that comes in another cell by writing in a cell

    2. If you are trying to make a nested formula for these situations then try this (since you haven't indicated whether the value of 0.20 is in above or below category, I have assumed it is above):
      =IF((AND(F15>0.26,F15=0.20)="truetrue","retained",IF((AND(F15>0.26,F15=0.20)="falsefalse","rejected",IF(AND(F15>0.26,F15=0.20)=FALSE,"revised","")))
      ?

    3. This is very simple. Just try this =IF(AND(F15>=0.26,F150.2),"Retained")
      =IF(AND(F15>=0.26,F15<=0.75,H15<0.2),"revised")
      =IF(AND(OR(F150.75),H15>0.2),"revised")
      =IF(AND(OR(F150.75),H15<0.2),"rejected")

  28. I have a beginning balance column that I need to Name in another column. so if "Tom's" Beginning Balance of $410 (Column E), then column H needs to identify him on the Standard Plan

    If Joe's Beginning Balance is $500 (Column E), then column H needs to identify him on the Enhanced Plan

    Thank you

    1. HI JRC.
      TRY THIS.

      =If(E1=410,"standard plan",IF(E1=500,"ENHANCED PLAN"))

  29. pls i wish to know the formulas for business account.

  30. Hello!
    i need some help
    if i have total amount 1000 which include 17% tax i need the true amount so what was the formula.

    1. hi.farhan.
      try this formula.

      =A1*17%+A1

  31. OBALE 45 86 95 98 98 422 45 98
    ASALE 87 67 76 98 88 416 67 98
    OPETO 56 34 32 43 67 232 32 67
    ATWANI 88 76 78 87 76 405 76 88

    32 98

    please can someone solve for me this because these five students did the exam and these are their max. so what i need is can someone show me how to get MAX value,MIN value,AVERAGE value,POSITION value,GRADE value and RANK values. Thanks or your assistance in advance.

  32. How to minus ex : 15% margin in investment amount
    Need the excel formula

  33. plz send all vlookup & Hlookup formula with example, and micro command from beginer

    1. Phle ek kam tera basic clear kar. phir VBA me jana. Pagal

  34. how do I enter a formula for the following
    Column A $5,000
    Column B gets 2500 Column C gets the difference I want Column d & E to calculate %. I also want to be able to change $ amount in B and have the $ amount and % automatically change based on whether I change $ or % amounts.

  35. Very good stuff. I have learnt a lot.

    Thank you All

  36. how to use in excel 2 nos*2500=5000

  37. i want know the all of excel formulas

  38. Please Send All Formula use excel sheet.

  39. What is the two types of components of formula that start in Letter O?

    1. Ipotse

  40. Another comparison operator, that must be mentioned, is ”between”. Formula for interval between 4 and 7 is: AND(A1>4, A1<7)

    1. Dr sir,I ask a reply my querry as follows:IF(A15800 & 300 if B1<5800.Pls let me know the formula.
      Kind regds.

  41. learn in excel formulas

  42. This formula is reyaly work Great work

  43. means if an employee salary is
    1- up to 5000 so 0% tax
    2- from 5001 up to 12500 2% tax
    3- from 12501 up to 100000 10% tax
    4- more than 100000 20% tax

  44. Hello,

    can you plz send me a formula for the below example

    An employee salary is 120000 so he will pay tax like
    1- 5000 = 0 tax
    2- 5001 - 12500 = 7500 x 2% = 150
    3- 12501 - 100000 = 87500 x 10% = 8750
    4- 20000 = 20000 x 20% = 4000

    so the total is 0+150+8750+4000= 12900

    waiting for your reply
    thanks
    Samimi

    1. =IF(K1<5000,0,K1-5000)*2%-IF(K1<12500,0,K1-12500)*2%+IF(K1<12500,0,K1-12500)*10%+IF(K1100000 and Percentage will be variable 20%-10%
      K1=120000

      down four formula has been combined with + which is showing above

      IF(K1<5000,0,K1-5000)*2%
      IF(K1<12500,0,K1-12500)*2%
      IF(K1<12500,0,K1-12500)*10%
      IF(K1<100000,0,K1-100000)*10%

  45. sumif

Post a comment



Thank you for your comment!
When posting a question, please be very clear and concise. This will help us provide a quick and relevant solution to
your query. We cannot guarantee that we will answer every question, but we'll do our best :)