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

  1. Let us suppose for a full 3 trip the amount to be paid is Rs-53 than what will be calculation if it is a partial trip as per below

    Partial Trip Deduction in amount
    86-95% 15%
    76-85% 30%
    61-75% 50%
    51-60% 60%
    26-50% 80%
    0-25% 100%

    in such case which excel formulae can be used.

  2. In exel
    A4=100%
    B4=100%
    C4=100%

    The condition is, if any 1 of the 3 is 100% & above, reward is 1000/-, if any 2 of the 3 are 100% & above, reward is 3000/- and if all the 3 are 100% & above reward is 6000/- how to write a formula

  3. I WANT WRITE TWO OR THREE NAMES ON A SHEET IN COLUMN A. I WANT TO KNOW THAT HOW TO CALCULATE THE NAME.

  4. Nice lessons, thanks alot

  5. may you please help.how can learn how to publish the all formulas so that i can learn the basis

  6. May you please help. how can I create a formula to get a total percentage mark in the following example, 50/80 contributes 75%, while 30/80 contributes 25% to the total mark. I am a beginner

  7. How can we assign values to variables so that they can be used in formulaes.like a=2000
    B=30000 and write a and b or other variables in excel and perform mathematical operations.

  8. How to convert numbers into words in excell

    As in P 500.30 to Five Hundred Pesos and Thirty Centavos Only

    Thank you

  9. Iam facing a problem in excel, I have two excel sheets column 1 in both sheets having same data but small variation like product name in one sheet Q18nuxa2- lhj and in other sheet q18nux -lhf but I want replace total data in column 1 of sheet1 with sheet 2 data. Any formula or shortcut keys i have a bulk data . so please help me any tips.

  10. What is the correct formulae or function of @SUM(B1::B5)

    1. Tamal:
      The formula looks as though it should be =SUM(B1:B5).
      It will sum the values in cells B1 through B5.

  11. Actually I need help
    So please help me

    1. If A1+C1+E1 same more row ,but how I want sum ,I use which formula,if I want same
      =A1+C1+E1+G1 so many times give

  12. Please Help me to Solve this

    I am entering 10 in cell B4 after entering the value the result should be 500*10bin the B4.

    1. Syam:
      Enter this in an empty cell:
      =B4*500

  13. please how do i calculate this in excel.

    0.98*In(1/0.98) + 0.02*In(1/0.02)

    1. Umar:
      If I'm reading this right the method is:
      In the cell you want to display the result enter
      =0.98*(1/0.98)+0.02*(1/0.02)
      Take the "In" out of the formula.
      If you need to display it in the result you can concatenate the "In" to the result with this formula
      =0.98*(1/0.98)+0.02*(1/0.02)&" In". Not the space before the "In".
      If you're trying to use the natural log function in Excel its symbol is LN and the formula looks like:
      =0.98*(LN(1/0.98))+(0.02*LN((1/0.02)))

  14. please send me formula

  15. I have sheet under
    BEFORE MRP VALUE
    1500
    1200
    900
    800
    700
    1800
    500
    how to Calculate 1000 Rupees Above 12% and below 1000 Rupees is 5% .

    1. Shridhar:
      Will this work?
      Where "Before MRP Value" is in column A.
      The sample is in cell A5 the formula looks like this:
      =IF(A5<=1000,A5*0.05,A5*0.12)
      It says, "If the value in A5 is less than or equal to 1000 then multiply it times 5%, otherwise multiply it times 12%."

  16. how to Calculate Gst Percentage Amount in below 1000 rupees and Above 1000 rupees ?
    per example 900 rupees is 5 % gst and 1000 rupees is 12% gst

  17. SIMPLER!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

  18. FORMULAR FOR MEAN IN CELL 3, IF CELL 1 = 20000, CELL 2=80000

  19. Al Wukair 3.50 Al Wukair 3.00 Al Wukair 2.00 Al Wukair 6.00 Al Jeryan 3.00 Al Jeryan 3.00 Al Jeryan 3.00

    above data is in horizontal i.e. in rows. number defined are overtime hours. how to sum for each location.

    advance thanks.
    amit lalchand kamwani

  20. fag

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

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

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

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

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

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

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

  28. 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???????

  29. I don't understand anything here

  30. How to count poor grade using count if function

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

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

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

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

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

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

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

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

  39. Hi very nice technological and teaching Excel formula simple

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

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

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

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

  44. Very nice formula of excel

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

  45. very nice teaching

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

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

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

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

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

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