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

  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

  21. I will type the KYC NO LIKE THAT GST NO, AADHAR NUMBER, PAN NUMBER & PASSPORT NO. NEXT COLOUM WE AUTOMATIC KYC TYPE LIKE THAT GST NO ( GSTIN NUMBER,) I NEED TO FORMULAS.

  22. Can you please help me with the formula regarding how to get the total number of males in a list containing both genders.

  23. I learn many things here

  24. Hi im trying to understand what this formula means from a staff matrix training excel spreadsheet =IF(D11="Assistant Operator",IF(AND(I11=2,COUNTIF(J11:O11,2)>2),2,1),"")

    Thank you

  25. A2:A700 different names, IF A2="Balanagar", then B2="Balanagar Division",C2="Balanagar Zone",D2="Cyberabad",, how do I write

  26. very helpful to me. thanks

  27. I need a help on having the summary of my calculation on another sheet. That is, as I am working the the full details on one page, the summary of the work will automatically be calculating itself on the next sheet. Thanks...

  28. hello dear

    if I wanna calucalate a1,a2,a3 + 5000 = b1,b2,b3
    then total of b1,b2,b3 - c1,c2,c3 =

  29. Well explained

  30. Easy to read.....

  31. How to add number of every sheet in last sheet. example-
    sheet1 c5+sheet2 c5+sheet3 c5 = Total on fourth sheet

  32. all excel shortcuts books 2003

  33. want to deduct value of column 'g'items from column' h ' items total values and multiply with column 'k' values can u help for the same

  34. wow it was realy heipfull to me,thanks.

  35. how to select and paste formula cells

  36. all is good

  37. if 1510.99 comes the result should 1510 and when 1511.1 comes then result should come 1520 .
    How to make this result?

  38. excel function
    a=0, b=500, but c=500/2 = 250 i need this calculation

  39. What is the formula for vlookup

    1. Hi Jishnu,

      The traditional way to vlookup in Excel is by using the VLOOKUP function. We have a special tutorial on this with many formula examples: VLOOKUP tutorial for beginners. Quite recently, Microsoft has introduced the new XLOOKUP function that can look both vertically and horizontally and overcomes some of the critical limitations of VLOOKUP. We have a comprehensive tutorial on XLOOKUP function, hopefully you will find it helpful.

  40. Very useful who is try to learn about excel and recall thanks good keep going on

  41. I need help in copying results from the next table with increasing numbers.
    For example
    Column b has the following:
    1. 20
    2. 30
    3. 40
    Then I need to transfer the info onto another sheet across a row
    A B C
    1. 20 30 40

    1. copy paste special with transpose.

  42. WEEK EXAMPLES ACCORDING TO THEORY

  43. Electricity Bill
    Units Rate

    1-100 2
    101-200 3
    200-above 4 Units Consumed Price
    50
    120
    80
    200
    100
    250

    1. =IF(A2<101,A2*2,IF(A2<201,A2*3,A2*4))

  44. Thanks

  45. Hi
    I need an assistance in function formula for CTC Calculator
    We calculate Basic salary on fixed monthly CTC at 40%, Hence if the monthly basic is above 15k, let the amount takes whatever it get calculated on 40% but if the monthly salary itself below 15k then whatever the amount is should get reflected in Basic salary itself not in any other component.
    Please do the needful

  46. Ex- 24546 =twenty four thousand five hundred forty six only (in formulas)

  47. it is very useful but example is less

  48. this was helpful

  49. I want to calculate TWO CELL also end of the calculation i want to add a TEXT (as a note)
    For Ex. :
    Key in info : =(A2-A3) Weeks
    want a result to be : 3 Weeks

    is it possible. pls answer me ASAP
    thanks

    1. I am giving you the simple formula,
      =(A2-A3)&" Week"

  50. i loved it and send me your email id in my email id

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