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 7. Total comments: 205

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

  2. 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

  3. 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!!

  4. Very nice formula of excel

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

  5. very nice teaching

  6. 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

  7. 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")

  8. 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"))

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

  10. 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

  11. 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.

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

  13. 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

  14. 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.

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

    Thank you All

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

  17. i want know the all of excel formulas

  18. Please Send All Formula use excel sheet.

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

    1. Ipotse

  20. 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.

  21. learn in excel formulas

  22. This formula is reyaly work Great work

  23. 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

  24. 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%

  25. 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 :)