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

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

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

  3. I learn many things here

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

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

  6. very helpful to me. thanks

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

  8. hello dear

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

  9. Well explained

  10. Easy to read.....

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

  12. all excel shortcuts books 2003

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

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

  15. how to select and paste formula cells

  16. all is good

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

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

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

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

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

  22. WEEK EXAMPLES ACCORDING TO THEORY

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

  24. Thanks

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

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

  27. it is very useful but example is less

  28. this was helpful

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

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

  31. SIR,
    I WANT HELP IN MARKING SCHEME
    ATTAIN = +4
    WRONG = -1
    LEFT = 0
    KEY IF A AND B BOTH THEN 4 (FOUR OPTION A,B,C,D, GRACE) a formula for this

  32. IF I WANT TO SUBSTRACT A7 TO A11 CELLS FROM CELL A6
    HOW CAN I DO THIS ONE

    1. =Sum(A7,A11)-A6

  33. how to apply the number convert to text for example 12= twele and apply a1=112 but the solution b2= one hundred and twele

  34. i will apply numbers only

  35. If E2 is under 2000 C7 should show 30%
    If E2 is between 2001 and 4000 C7 should show 40%
    If E2 is under 4001 and over C7 should show 50%
    Please help to get a formula for this

    1. =IF(A4<2001,"30%",IF(A4<=4000,"40%","50"%))

    2. If E2 is under 2000 C7 should show 30%
      If E2 is between 2001 and 4000 C7 should show 40%
      If E2 is over 4001 and over C7 should show 50%
      Please help to get a formula for this

  36. More than this

  37. It takes me Only a day to learned all the formulas..
    Very Helpfull..

  38. thank you

  39. Hello, I am trying to make a time sheet. Here is the example:
    Start time: 12:30 am
    Regular hours: 4.5 hours
    Extra hours: 40 minutes
    Break: 30 minutes if total hours more than 5 hours
    Finish Time: ??? I need the formula which should be 6:10 am as total hour more than 5.
    Total hours: 5.16 hours

    Thanks for your help.

  40. how to convert number in figures., as 1,000.00 (One thousand)

    1. Try spell number, spell number Indian formula , its a customized formula. Google it....

  41. I need assistance whereby i HAVE TWO CELLS,ONE WITH PRIMARY BORROWED AMOUNT THEN SECOND ONE WITH THE INTEREST OF THE BORROWED MONEY

  42. I want set up a spread sheet whereby i have a value on one cell and the percentage of that value in another cell,for example i have $1000 in cell B and in cell C i will want to have 25% of whatever value is in cell B(in this case $1000)
    regards
    Waugh

    1. a simple formula would be
      =B1*0.25 OR IF IT A DIFFERENT PERCENTAGE EG 10% =B1*0.1

  43. Good work microsoft exel

  44. Dear Team
    I want to know about the best techniques of the excel with formulas & functions.

    if you provide best techniques, i shall be obliged

  45. I want to know about main formula of ms excel

    1. can i help u

      1. Hai I would like to ask a help for my report Training about excel formula i want to know more about this...please

  46. This content is very useful but example is not good

    1. Hi Sunny,
      I have updated some of the formula examples. Hope they make more sense now :)

      1. can you please show the percantage formula

      2. You are excellent,Thank you for your content it is very helpful to us.

      3. yes svetlana i want to know that the examples

  47. if a C3 value is 4.65 then D3 should show 50%
    if a C3 value is between 4.20 and 4.65 then D3 should show 45%

    Please help to get a formula on this

    1. =IF(A4>=4.2,IF(A4<=4.64,"45%","50%"))

  48. Ms excel word sheet pdf

  49. I want to Calculate, A Value of 2323.56 it should covert to nearest ten value @ 2330 can anyone tell which formula to use.

  50. i want to calculate expenses, if container is of 20ft then the total amount should be different, and if container is of 40ft then also the amount should come different. can anyone tell which formula to use as it should be in one cell only.

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