Comments on: Basic Excel formulas & functions with examples

Being primarily designed as a spreadsheet program, Microsoft Excel is extremely powerful and versatile when it comes to calculating numbers or solving math and engineering problems. This tutorial aims to teach you the essentials of Excel functions and show how to use basic formulas in Excel. Continue reading →

Comments page 14. Total comments: 413

  1. Say
    buyer X received 123 pcs from unit 1
    buyer X received 500 pcs from unit 2
    buyer X received 280 pcs from unit 3
    buyer y received 123 pcs from unit 3
    buyer y received 123 pcs from unit 1
    buyer Z received 123 pcs from unit 2
    buyer Z received 123 pcs from unit 1
    Please put formula who I calculate buyer wise and unit wise received total qty

  2. Give me the formula name for
    C3*C4%+C3

  3. Very good
    Can u teach us how to make general ledger tria balance

  4. SR NO FORUMAULA

  5. IF I HAVE TWO COLOMS A & B WHERE "A" HAS MATERIAL AND "B" HAS QTY. AND DON'T WANT TO FILTER TO COUNT PARTICULAR QTY FOR MATERIAL ,SO I WILL DO WORK IN A NEW COLOM "D" AS MATERIAL AND "E" QTY AND WHAT I NEED HELP THAT AUTOMATICALLY QTY ADD UP IN COLOM "D" & "E" WHEN I WILL DO ENTRY IN "A" & "B"..PLEASE REVERT ME IF YOU NEED SCREEN SHOT OF MY WORK...

  6. nice explanation

  7. if Total cost is 10000. i want to calculate what is the value which includes 12% in 10000. Tell me the formula pl.

    1. ex: TOTAL COST A1
      PRICE :=A1*100/112

  8. REALLY VERY HELPFUL THANKU

  9. =num2text FIGURES TO WORDS

  10. Hello,
    I have been asked to extract the number from the following list without using MID as this only works when all the results are the same type.
    TX TO 2014016 CHG ORG
    TX TO 1832298CHG ORG DEN
    TX TO 1854600 CHG ORG
    TX TO 1971447
    TX TO 1980547 CHG ORG
    Any help is appreciated

    1. Hello,

      If you need to avoid using the MID function to fulfill your task, then I can recommend you to try extracting numbers from your list of data with the help of the Extract Text tool.

  11. I sew and i believe about all form A.I.A

  12. Do data jaise colume A or colume B dono ka data colume A me Lana hai to kon SA formula use hoga

    1. K L
      COLUMN COLUMN

      R M =CONCATENATE(K15," ",L15)
      = R M
      = " " STANDS FOR SPACE

  13. Qut Amount Discount Amount
    2 300 20% ===

  14. THANKS YOU

  15. Sum (no1, no 2)

  16. if sheet 1 - particular cell value is visible in sheet 2 - What is the formula for that?

  17. Deduction under VI A in incometax calulation is 150000 but Candidate Have Deduction more then 150000 or Less than 150000 we want to rebate only 150000 what is the formula in exel

  18. Sorry, my typing was inaccurate, the first column should be Monthly Basic Salary x 2.75% with values that ranges from P10,000 to P40,000. The second column should be Monthly Premium with values P275, P275.02-P1,099.99 & P1,100.

    Hope this is clear now.
    Thanks

    1. Hello,

      Supposing that your table starts from A1, please try to do the following:

      1. Enter P10,000.00 in cell A2;
      2. Enter the following formula in cell B2:
      =A2*2.75%
      3. Select the cells with your data and drag the fill handle (a small square at the lower right-hand corner of the selected cell) down.

      Hope it will help you.

  19. Hi, can you help me create a formula for below table? I have tried but there is lacking in result for the condition of P40,000 and above.

    Monthly Basic Monthly
    Salary x 2.75% Premium

    P10,000.00 & below P275
    P10,000.01-P39,999.99 P275.02-P1,099.99
    P40,000.00 & above P1,100.00

    Thank you in advance.

  20. explain excel

  21. Hi, I need to calculate % discount in my spreadsheet, I need a kind assistance. Thanks.

    1. Hello,
      For me to understand the problem better, please send me a small sample workbook with your source data and the result you expect to get to support@ablebits.com. Please don't worry if you have confidential information there, we never disclose the data we get from our customers and delete it as soon as the problem is resolved.
      Please also don't forget to include the link to this comment into your email.
      I'll look into your task and try to help.

  22. dear concern:
    in excel i cant correct the below function .please help me
    04KRKKRK i want to delete 04KRK AD ADD 04BNUKRK at whole list.plz
    04KRKKRK
    04KRKKRK
    04KRKKRK
    04KRKKRK
    up to 1000

    1. A B C D
      04KRKKRK =LEFT(3,A1) YOURWRLD =B1&""&C1 (COPY THAT IN ALL CELL)
      04KRKKRK
      04KRKKRK

  23. HELLO..can anyone help me using formulas in payroll?

    heres the data summary example:
    name rate/mo deductions total net
    sss phic hdmf deductions pay
    1) A 13000 1200 125 500 1825 11175
    2) B 25000 1700 125 1000 2825 22175

    what i want is in a certain payslip i just encode #1 then all the details will come out in just one click...is it possible?

    thank u for the guidance.

    1. Hello,

      For me to understand the problem better, please send me a small sample workbook with your source data and the result you expect to get to support@ablebits.com. Please don't worry if you have confidential information there, we never disclose the data we get from our customers and delete it as soon as the problem is resolved.
      Please also don't forget to include the link to this comment into your email.

      I'll look into your task and try to help.

  24. At first you must have the time of particular date then can find through apply below formula.

    =int(time-date)

  25. Hello,
    Can anyone tell me how can I calculate elapsed days if I have a date & time in place.

    such as I want to calculate how much time has been elapsed till this time from the given date & time.
    2017-11-13 19:35:19

    1. Hello,

      Please try the following formula:

      =DATEDIF(A1,IF(TIME(HOUR(A1),MINUTE(A1), SECOND(A1))> TIME(HOUR(NOW()),MINUTE(NOW()),SECOND(NOW())),NOW()-1,NOW()),"D")&" days "&HOUR((1-VALUE(TIME(HOUR(A1),MINUTE(A1), SECOND(A1))))+ VALUE(TIME(HOUR(NOW()), MINUTE(NOW()), SECOND(NOW()))))&" hours "&MINUTE((1-VALUE(TIME(HOUR(A1),MINUTE(A1),SECOND(A1))))+ VALUE(TIME(HOUR(NOW()),MINUTE(NOW()),SECOND(NOW()))))&" minutes "&SECOND((1-VALUE(TIME(HOUR(A1), MINUTE(A1), SECOND(A1))))+ VALUE(TIME(HOUR(NOW()), MINUTE(NOW()), SECOND(NOW()))))&" seconds"

      Hope it will help you.

      1. Great Dear But it is Not Automatic I have to refresh then it will work please do work for this Automatic Running line Hours Mints and secound

  26. Please what does this formula mean in a sentence form?

    =RANK(A2,A$2:A$8)&MID("thstndrdth",MIN(9,2*RIGHT(RANK(A2,A$2:A$8))*(MOD(RANK(A2,A$2:A$8)-11,100)>2)+1),2)

  27. Hi, I want to know what vlookup can use in "if". Means it the condition is true then vlookup will run.

    1. Hi Babu,
      You can nest a Vlookup formula in the value_if_true argument of the IF function like this:
      =IF(logical_test, VLOOKUP(...), "")

  28. Plese send the transfer to number in word formula

  29. good

  30. =IF(COUNTIF(A2:E2,"0")=5, "STRONG", IF(COUNTIF(A2:E2,"0")=4,"GOOD",IF(COUNTIF(A2:E2,"0")=3, "POSITIVE","WEAK")))

  31. if in sheet 1 there is a roll no of student in A1 and class in B1. I want that I write roll no in sheet 2 A1 and class automatically written in sheet 2

    1. Hello, Shakeel,

      I'm afraid there's no easy way to solve your task with a formula. Using a VBA macro would be the best option here.

      However, since we do not cover the programming area (VBA-related questions), I can advice you to try and look for the solution in VBA sections on mrexcel.com or excelforum.com.

      Sorry I can't assist you better.

  32. Woww. I have learnt Excel...

  33. plz give me all excel forumullas

  34. Pls give me excell formulas with example i need ......

  35. Thank you

  36. Excel Is Mathematical App So We Need More Explanation About Ms~excel

  37. Hi there!

    You can use the following formula:

    =IF(COUNTIF(A2:E2,">0")=5,"STRONG", IF(COUNTIF(A2:E2,">0")=4,"GOOD", IF(COUNTIF(A2:E2,">0")=3,"POSITIVE","WEAK")))

    Hope this will help you :)

  38. thanks that was so useful for me!

  39. please send all excel formulas with explanation for both windows and apple iOS

    1. Hello,

      you can see the full list of all the Excel functions on this web-page. They can be used in both, Windows and Mac.
      If you want to improve your knowledge of Excel formulas and functions, you can subscribe to our blog feed by clicking on the "Register" link on the right side of this page.

      Every week we post different tips and tricks on our blog that will help you to solve every-day tasks in Excel.

      Hope you will find this information helpful.

  40. Hi Svetlana,
    I am working percentage. here's my need. I must calculate 5% of a sum but there's a cap for eg.

    5% of 125,000 = 6,250 (this is the ceiling)
    if the sum increases to 130,000 the ceiling can't be exceeded.

    So I need a formula to tell the cell to calculate 5% of the particular amount up to 125,000 but apply the ceiling of 6250 whenever 125,000 is exceeded.

    Hope I explained simply enough.

    Thank you!

    1. Easiest way is to use an IF Function:

      =if(A1<=125000,A1*.05,6250)

      In this case, A1 is the sum you are trying to multiply by 5%

      1. I think you are just trying to act smart

  41. Thank you friend

  42. Hi,

    How to highlight the value in a cell whenever which is higher than that of in the preceding cell? Is such function found in conditional formatting?

    12.94 12.94 13.00 12.93 12.92 12.91 12.9 12.89 12.89 12.9 12.89

    Thanks.

  43. madam

    excel if, else condition formala example sent my email id

  44. Hey there,

    I want one formula wherein,

    A B C D E
    1 0 2 4 5
    If all of the above columns are greater than 0 then result would be "STRONG", If any 4 of the above columns are greater than 0 then the result would be "GOOD" and if any 3 of the above columns are greater than 0 then result would be "POSITIVE" otherwise it would be "WEAK".

    It would be really great if you may help in this.

    Thanks & regards,

    Ankita Matalia

    1. Hi there!

      You can use the following formula:

      =IF(COUNTIF(A2:E2,">0")=5,"STRONG",IF(COUNTIF(A2:E2,">0")=4,"GOOD",IF(COUNTIF(A2:E2,">0")=3,"POSITIVE","WEAK")))

      Hope this will help you :)

  45. good

  46. ms excle all formula list

  47. Thank's Svetlana.

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