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

  1. MF:( i don't know how to use excel:((((((((((

  2. 200 100 = 100
    300 400 = -100 300-400=0 Passible
    400 300 = 100
    500 600 = -100

    1. Hello!
      Sorry, I do not fully understand the task. Could you please describe it in more detail? What result do you want to get? Thank you!

  3. I'm looking for a formula to calculate National Insurance payments please-
    Under £183 = 0%
    £183.01- £962 = 12%
    £962.01+ = 2%
    Im thinking SUMPRODUCT but getting lost, Thank you

    1. Hello!
      For me to be able to help you better, please describe your task in more detail. I cannot know how these payments are made. Please specify what you were trying to find, what formula you used and what problem or error occurred. Give an example of the source data and the expected result.
      It’ll help me understand it better and find a solution for you.

      1. 300-500=0

  4. Good day.
    I have a spread sheet of 300+ line. I want to add a formula what hides values what is the same amount, but opposite (positive and negetive).
    A1 -35,00
    B1 -34,80
    C1 -33,26
    D1 -15,00
    E1 32,12
    F1 33,26
    G1 34,80

    Example:
    A1 - Stay
    (B1,G1) Hide
    (C1,F1) Hide
    D1 - Stay
    E1 - Stay

    Thank you

    1. Hello!
      You haven't specified exactly how you want to hide the values. However, you can use conditional formatting in your table.
      Use condition formula

      =SUM(--(1:1=-A1))=1

      For this condition, you can set the font color to white in the cell.

  5. How can I get only numerical numbers from text.
    Examples:-
    Hi please check 54618464
    51856792 requirements cleared
    Please check 3192675 and confirm

  6. Hi,Kindly guide me
    In column K check condition 1,2,3,4 then get value from column H and sum value below another table according to 1,2,3,4

    1. Hello!
      I’m sorry but your task is not entirely clear to me. For me to be able to help you better, please describe your task in more detail. Please specify what you were trying to find, what formula you used and what problem or error occurred. Give an example of the source data and the expected result.
      It’ll help me understand it better and find a solution for you.

  7. GOOD DAY

    COULD SOMEONE PLEASE ASSIST ME.
    i AM TRYING TO WORK OUT A FORMULA PLEASE SEE BELOW.
    PART DESCRIPTION PART NUMBER QTY UNIT PRICE DISCOUNT SUB TOTAL
    BULB 2 R50 15% R85
    SO HOW DO i WORK OUT THE FORMULA TO SAY R50 X 2 -15% WILL = R85.

  8. I have one Excel marklist that displays marks out of 100 in all subjects(10 subjects). I want to reduce all marks in the marklist to half.how can i do that for entire marklist.pls reply urgent

  9. Hi
    I new to Excel and being a complete Brain Dead moment i am trying to do a balance sheet,and I just cant seem to get old ballance showing new ballance value. It's a simple spreadsheet where:

    I have 3 columns.
    B2 is current balance £100
    C2 is Payment £30
    D2 is Balance £70
    BUT I then want B2 to show new ballance D2.
    Ie: B2 is Owing £100 C2 is I pay £30. D2 NEW BALANCE of £70. Then B2 shows new ballance of D2 £70.
    Hope this helps and thank you
    Pete

  10. lots of time taken while reading ,but it's more useful when work in excel with your tips to reduce working time ...thanks for sharing the valuble one..

  11. "Your students have completed their oral and written exams and you need to get their grade. If they received greater than or equal to 85 in both parts they will get a grade of A otherwise the grade is a Pass.
    Create the formula you would enter."
    Can you help me create this formula?
    Thank you for your help.

    1. Hello!
      I’m sorry but your task is not entirely clear to me.
      Please describe your problem in more detail. Include an example of the source data and the result you want to get. It’ll help me understand your request better and find a solution for you. Thank you.

  12. =+Sheet1!D7 what does it mean

  13. I'm trying to error proof an excel sheet. I need for the input be between 113.5 to 116.5. if it falls in-between that range then it's ok, if not then it highlights that cell in red.

  14. hello Please provide me PDF File Excel Formula Basic to all excel formula

  15. If there are number of releatative items in column. Ex.
    A 1
    B 3
    A 5
    C 1
    D 3
    B 2
    I want to make column of from above data like
    A
    B
    C
    D

  16. What does the at (@) symbol do in a formula?

    1. Hi Larry,

      The @ symbol is used in structured references (table references) to refer to cells in the same row where the formula is. Typically, the @ character is followed by the column name.

      For example, the following formula adds up numbers in the "South" and "West" columns of the current row in the table named "Regions":
      =SUM(Regions[@South], Regions[@West])

      For more information, please see How to use structured references in Excel tables.

  17. I love that, they are all interested.

  18. Hi,
    Please provide me PDF File Excel Formula Basic to all excel formula

  19. How to apply formula Top 7 Pivot Table Treks in Excel
    Send me for example.

  20. SUPERB

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