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

  1. How to write this in excel
    Price divide by 1.16 minus 40%

  2. i had came across a spreadsheet were it has a table with titles that doesn't change when you flip a page, typing a specific year to a assign field that it is already navigated by the developer of the template..... i am working on a spreadsheet recording salary for a corporation, and i was wondering if only you can help me create a task to a cell that only act like flipping pages within the same worksheet were default information remain along while the information reflect the change when data are enter and falls in specific time range that is assign to each page.

    This template I'm referring to is something to do with a Budget vs Actual template.

  3. I want set a maximum number like 3, where any value which greater than 3 it become into 3. Is it possible ?

  4. How I can with the same cell to for varying cell. I need the syntax. Example: I3*C17+I4*D17+I5*E17+I6*F17+I7*G17+I8*H17 the I3, I4 .... I8 I don't want to vary when their multiplier varies from cell to cell.
    Regards,

    1. Hello!
      If I understand your task correctly, the following formula should work for you:

      =SUMPRODUCT(I3:I7,TRANSPOSE(C17:G17))

  5. =IF(MONTH(DATE((RIGHT(A1,4))+1,2,29))=2,DATE((RIGHT(A1,4))+8,1,1)+((MID(A1,4,2))*30-120+(LEFT(A1,2))-22),DATE((RIGHT(A1,4))+8,1,1)+((MID(A1,4,2))*30-120+(LEFT(A1,2))-23))
    what wrong with this formula? I can not fix the error.

  6. What is the formula to always add the same cell as you draw down a column? eg. Wish to add the value in A1 after the cell has calculated a formula and be able to see the difference down the list if I change the single value in A1
    Example:
    Cell A3=A2+A1
    Cell A4=A3+A1
    Cell A5=A4+A1.......down to cell A700

    1. Hello!
      If I understand your task correctly, the following formula should work for you:

      =A2+$A$1

      Please check out this article to learn how to use $ in Excel formula

      1. Thankyou, this is exactly what I asked for. 10/10

  7. I have two spread sheet one of i yellow collar highlighted one of my active partner name and business registration number , other spread. sheet desperately are include all businesses name , now i want second spread sheet category a active and inactive , how i can get first spread sheet detail collared name as machine in to second sheet

  8. how to adjustment of per rate formula in excel

  9. I want to show grace marks obtained by a student in the marksheet along with the grace marks symbol. Ex. 30+3
    33+

  10. Great site. Cheers for posting.

  11. HELLO,
    wanted help in how u gonna write a formula for summing the total of mark up to 100 buh prompting the user on a total score greater than 100 and less than zero

  12. i have a problem, when i want to write a formula to add marks to the average scored of student who scored 44 (included) and 50 ( excluded) to get new average

    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

  13. how to count name from different sheet in excel

  14. WHAT IS THE CORRECT EXCEL FORMULA FOR CELL M16…M27 TO CALCULATE THE NET DISCOUNT

    1. Hi,
      Please describe your problem in more detail. It’ll help me understand it better and find a solution for you.

  15. I didn't like these examples

    1. Hi,
      Have you tried the ways described in this blog post? If they don’t work for you, then please describe your task in detail, I’ll try to suggest a solution.

  16. I want to know 475 formulas of excel

    1. But its help me a lot thank you for it

  17. Thanks for sending? from ??

  18. It really helps me to do my IT practicle file

  19. Hi,
    I am not sure I fully understand what you mean.
    Could you please describe it in more detail? What result do you want to get?

    1. Noice and nice

  20. Hi
    I m using excell in office but i want to save formula for name displaying system. For eg (By typing its pan number it should display its name saved in excell in next column) please help me

    Thank You

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

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

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

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

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

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

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

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

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

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

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

  32. =+Sheet1!D7 what does it mean

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

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

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

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

  37. I love that, they are all interested.

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

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

  40. SUPERB

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

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

  43. I learn many things here

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

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

  46. very helpful to me. thanks

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

  48. hello dear

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

  49. Well explained

  50. Easy to read.....

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