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

  1. HI,

    i need a formula to remove kilogram in tons in excel .

    Example-
    I brought an Item weight off 26000 tons and i need to remove 5 kilograms from each ton.

  2. this many formulas how can i write in exam
    hall today?

    1. leave that one

      1. it carries 4 marks how can i leave that one and the exam is 60 only and duration is 2 hours but we get three hours and this type of question we cannot ask any one cause it is very big answer.

        1. ok see you later

          1. wait! wait! wait!

  3. =Countif(Reqs!B1:B,"Name"+(Reqs!H1:H,"Yes"))

    Obviously this is wrong but im not experienced enough to correct it.
    Basically i have column B with a name And Column H with either "Yes" or Blank.
    I need to write a formula for if theres The name and Yes in column H. it equals 1 on a different sheet.
    Reqs is the tab columb B is the names and H is Yes or blank
    Any advice?
    Thanks in advance.

    1. If you only wanted to count how many "YES", just type =COUNTIF(Reqs!H1:H1000,"YES), but if you want to count if column be has name =COUNTA(Reqs!B1:B1000)

  4. How to convert numbers into words in excell

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

    Thank you

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

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

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

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

  9. 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%."

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

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

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

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

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

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

  16. Very nice formula of excel

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

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

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

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

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

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

    1. Ipotse

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

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

Post a comment



Thanks for your comment! Please note that all comments are pre-moderated, and off-topic ones may be deleted.
For faster help, please keep your question clear and concise. While we can't guarantee a reply to every question, we'll do our best to respond :)