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

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

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

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

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

    =int(time-date)

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

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

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

  8. Plese send the transfer to number in word formula

  9. good

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

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

  12. Woww. I have learnt Excel...

  13. plz give me all excel forumullas

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

  15. Thank you

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

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

  18. thanks that was so useful for me!

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

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

  21. Thank you friend

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

  23. madam

    excel if, else condition formala example sent my email id

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

  25. good

  26. ms excle all formula list

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