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

  1. how to convert date from number to dot format in excel
    for uploading in SAP format

  2. Tables!$D$14:$E$49, this is the formula that is seen on a cell of excel, can you explain to me how to track that table

  3. I want to know how to copy "now" formula for a whole row or column. By which i can get time exect to that related cell.

  4. carry a total from one worksheet to another in the same workbook? Need formula, please

  5. >6000 DA is 15%
    4000 to 6000 DA is 12%
    <4000 DA is 10%
    suggest me the formula

  6. Please give me advice how I can lock cell protect from VBA code.

  7. I must say that I am reading thru all comments, etc and I must say I am very impressed.
    For me what I am working on is simple; 1 sheet has all my menu items with the before and after taxes, mark up 30%, 32%, menu price with g.s.t. and price without g.s.t.
    2nd sheet has stock with price/numbers i.e. Carrots: 10#; 8.99$, 1 # cost x, 1 oz costs X
    3rd sheet has all and I mean all recipe.
    Simply put, I would like to enter i.e. cost of 1 # of carrots (from sheet 2 to sheet 3) into my recipe on sheet 2. Then the end cost (bottom line) import it into Sheet 1 under say Soup du jour. Just that simple.
    I'll get there soon. p.s. really appreciate all those feedback's on Excell

  8. Suggest me a formula for this
    if Cell A1 has value (27.5*6.25/2*2) i put formula in cell B1 =27.5*6.25/2*2 it shows value 171.88 but when i change value in cell a1 it should change in the value in cell B1

  9. Please gimme advice. I need one formula ex.cell a1 value -3 multiple b1 or cell a1 value 3 multiple c1

  10. Simple question...What is the formula I should use if I want a column to list consecutive dates, such as 2001, 2002, 2003...2035, without having to type each year in a cell manually? It is similar to the @sum formula.

  11. Good day
    If I have a list price and a nett, how do I work out the discount?
    Thank you

  12. How can we make Total of Particular Columns one colored cell (ie 'C' column's only red colored cell's value have to make total?

  13. These are very useful

    1. These are really very useful

  14. 70/28 and 30/12 how to Sum this two numbers

  15. Formulas are very useful. I am using it from a long time. Thanks Ablebits.

  16. Hi,
    I am trying to use the IF to creat a formula but the system is limiting to 9 Nine arguments. I would wish to create 17 arguments. Please assist.
    Thank you

  17. I'm very thankful for those basic formula that i have seen and learned in this site, it such a big help in my day to day work and great thing that can develop my learning in excel. thankyou.

  18. Hi I have a client with two spreadsheets. One has an inventory on it so the first column is the stock number for a certain product and then there is a quantity column further along.
    The other tab is a Purchases column and we are wanting to be able to add a recurring stock number or new stock number and the quantity of product for that item just received. I am wanting to link the information from the Purchases tab to the inventory so that it will update the quantity list in the inventory stock list automatically.
    Is there a formula for doing this?
    Thank you in advance
    Alina

    1. Type in =vlookup.type the cell containing common column, press ,
      Then drag all the data from the other sheet press , again. Then press the column position to which you want the data from. press , and type zero. Close parenthesis and but enter

  19. I need day Calculation as like
    Join Date- 01.01.2018
    last date 03.06.2019
    = 00 month 00 days

  20. Dear Support, please can you assist with formula in excel to increment data in cell as follows: Cell A1 > 0 - 7 , Cell A2 > 8 - 15 , A3 > 16 - 23 etc...
    i.e each time value to increase by 8.
    Thank you for you valuable support and advise.
    Regards.

  21. Send me average formula in full form

  22. PLEASE TELL ME FORMULAS OF ATTENDENCE-SHEET

  23. Hi, anybody can help me
    Iam customizing inventory file consisting table like this;
    example:
    Item SI# DR# QTY RUNNING TOTAL
    if I input under SI# any text or number, the input qty will be added under running total;
    then, if input under DR#, any text or number the input qty will be deducted under running total,
    Please show me how to do the formulas.
    Thanking you in advance.

  24. your work is so helpful to the world

  25. pls send some useful formula for excel.

  26. Hi,
    Please give me a solution in a excel formulas. 5026*50%=2513 but I want to show the amount with round 2500. like 6055*50%=3027.5 but it'll be 3000 and total amount will be 2500+3000=5500.

    Thanks

  27. I need help about how to compile a home household budget

  28. How to shipment# 1000199990030 formula function? It's short #19999 column down countn

  29. I am pretty new to Excel. I cant get this formula right. Please help.
    In cell N25 from Excel Worksheet 2 below, write a function to sum the Account amounts in cells M8 to N22 and round the results to the 2nd digit. Write the function such that it can be copied or dragged down from cell N25 to cells N26 through N33. *

  30. Dear Sir/ Ma"am,
    Will you please tell me, how to use macros?
    Thanks in Advance

  31. Please tell me how to copy a cell value into another cell but if the original cell is a (-) figure it should now become (+) and vice versa

    1. Hi Emma,
      Use this Formula,
      =If(F12>0,(-1)*F12,(-1)*F12)
      where, F12 is the cell, which you want to copy.

  32. Please man /sir replayed me how can i use countifs cintex in any data.

  33. How am I use countifs in any data.

  34. hello mam i have no knoweldge of excel.so you can tell , how do you use ecxel in the computer.

  35. Sir I want to know the how to convert the no(56) into the letter(Fifty Six) in excel with using the formula of excel or using function of excel.

  36. Sir / Mam
    I want to write 06 in formula bar but it always show 6. Please any solution give me Sir.
    Thanks

    1. write like this '06

  37. Any formula for calculate of
    If I have 80boxes, 1carton = 30boxes
    I need answer is 2cartoon 20boxes
    Can help me set the formula, thanks.

  38. i have a small clarification regarding formula creation we creating some excel supplier wise part wise we want to count each supplier wise part wise

    supplier:
    1.america
    2.africa

    america Part details:
    1.aa
    2.bb
    africa Part details:
    1.cc
    2.dd

  39. thank you so much

  40. Hi,

    I have made up a spreadsheet with costings in column D (example). Each row in column D is of different value, how can I copy or create a formula that will multiply my markup of 38% (1.38) and then divide by currency (13). So for example =D12 is 12.75*1.38/13. Problem is that if I copy the formula from D12 all through to D23 it changes the value in each row to the value in D12 (12.75)
    Hope this is making sense (oh my)

  41. Good Afternoon,

    Please show me the formula I need to use to add columns B11 thru H11 in addition to adding 10% all in one cell.
    Thank you,

    Noreen

    1. Hello, Noreen,
      If we understand your task correctly, please use the following formula to solve it:

      =SUM(B11:H11)+SUM(B11:H11) *10%

      Hope this is what you need.

  42. I have in a cell a range date for example
    1-12 - 1-19 and I would like to change to a Jan-12 - Jan 19
    What is the formula for it?
    Thanks

    1. Hello, Olga,
      Thank you for your interesting question.

      Please try the following formula:

      =CONCATENATE(INDEX({"jan","feb","mar","apr","may","jun","jul","aug","sep","oct","nov","dec"}, MID(A1, 1, FIND("-", A1, 1)-1)), MID(RIGHT(A1, LEN(A1)-FIND("-", A1, 1)+1), 1, FIND(" - ", RIGHT(A1, LEN(A1)-FIND("-", A1, 1)+1))+2),INDEX({"jan","feb","mar","apr","may","jun","jul","aug","sep","oct","nov","dec"},LEFT(MID(RIGHT(A1, LEN(A1)-FIND("-", A1, 1)+1),FIND(" - ", RIGHT(A1, LEN(A1)-FIND("-", A1, 1)+1))+3, 10),FIND("-",MID(RIGHT(A1, LEN(A1)-FIND("-", A1, 1)+1),FIND(" - ", RIGHT(A1, LEN(A1)-FIND("-", A1, 1)+1))+3,10))-1)),MID(MID(RIGHT(A1, LEN(A1)-FIND("-", A1, 1)+1),FIND(" - ", RIGHT(A1, LEN(A1)-FIND("-", A1, 1)+1))+3, 10),FIND("-", MID(RIGHT(A1, LEN(A1)-FIND("-", A1, 1)+1),FIND(" - ", RIGHT(A1, LEN(A1)-FIND("-", A1, 1)+1))+3, 10)), 10))

      Please note that this is an array formula. You should enter this formula into a cell in any column and hit Ctrl + Shift + Enter to complete it. Copy the formula down along the column if necessary by selecting the cell where you've entered the formula and drag the fill handle (a small square at the lower right-hand corner of the selected cell) down.

      Hope it will help you.

  43. Good

  44. hi

    could you please have you tel me where i get more information about condition formatting

  45. Update to clarify my request:

    The "300" in the input cell could be increased manually to any number 500, 1200 ..... or 5000
    A1 = "input cell", the next 12 cells B1 to M1: each cell should be filled with a 100 as long A1 increased by 100
    if A1= 1043; B1=C1=D1=E1=F1=G1=H1=I1=J1=K1=100; but L1=M1=0 & N1=43
    N1= A1-(sum(B1:M1)) if A1 >1200 or N1= 0 if A1 <= 1200

  46. Hi, I'm tring to find a formela to divide the input value to the next cells as 100s.
    example: if A2= 200, then B2=100, C2=100, D2=0 and E2=0
    and if A2 changed to 300 then B2=100, C2=100, D2=100 and E2=0.

    Best regard.

  47. Display the highest and lowest marks in each test also give one appropriate leading

  48. I have a problem in my excel coding

    (this coding
    Function Rup(amt As Variant) As Variant
    Dim FIGURE As Variant
    Dim LENFIG As Integer
    Dim i As Integer
    Dim WORDs(19) As String
    Dim tens(9) As String
    WORDs(1) = "ONE"
    WORDs(2) = "TWO"
    WORDs(3) = "TRE"
    WORDs(4) = "FUR"
    WORDs(5) = "FIV"
    WORDs(6) = "SIX"
    WORDs(7) = "SVN"
    WORDs(8) = "EIT"
    WORDs(9) = "NIN"
    WORDs(0) = "ZER"
    WORDs(11) = "Eleven"
    WORDs(12) = "Twelve"
    WORDs(13) = "Thirteen"
    WORDs(14) = "Fourteen"
    WORDs(15) = "Fifteen"
    WORDs(16) = "Sixteen"
    WORDs(17) = "Seventeen"
    WORDs(18) = "Eighteen"
    WORDs(19) = "Nineteen"
    tens(2) = "Twenty"
    tens(3) = "Thirty"
    tens(4) = "Fourty"
    tens(5) = "Fifty"
    tens(6) = "Sixty"
    tens(7) = "Seventy"
    tens(8) = "Eighty"
    tens(9) = "Ninety"
    FIGURE = amt
    FIGURE = Format(FIGURE, "FIXED")
    FIGLEN = Len(FIGURE)
    If FIGLEN < 12 Then
    FIGURE = Space(12 - FIGLEN) & FIGURE
    End If
    For i = 1 To 3
    If Val(Left(FIGURE, 2)) 0 Then
    Rup = Rup & WORDs(Val(Left(FIGURE, 2)))
    ElseIf Val(Left(FIGURE, 2)) > 19 Then
    Rup = Rup & tens(Val(Left(FIGURE, 1)))
    Rup = Rup & WORDs(Val(Right(Left(FIGURE, 2), 1)))
    End If
    If i = 1 And Val(Left(FIGURE, 2)) > 0 Then
    Rup = Rup & " Crore "
    ElseIf i = 2 And Val(Left(FIGURE, 2)) > 0 Then
    Rup = Rup & " Lakh "
    ElseIf i = 3 And Val(Left(FIGURE, 2)) > 0 Then
    Rup = Rup & " Thousand "
    End If
    FIGURE = Mid(FIGURE, 3)
    Next i
    If Val(Left(FIGURE, 1)) > 0 Then
    Rup = Rup & WORDs(Val(Left(FIGURE, 1))) + " Hundred "
    End If
    FIGURE = Mid(FIGURE, 2)
    If Val(Left(FIGURE, 2)) 0 Then
    Rup = Rup & WORDs(Val(Left(FIGURE, 2)))
    ElseIf Val(Left(FIGURE, 2)) > 19 Then
    Rup = Rup & tens(Val(Left(FIGURE, 1)))
    Rup = Rup & WORDs(Val(Right(Left(FIGURE, 2), 1)))
    End If
    FIGURE = Mid(FIGURE, 4)
    If Val(FIGURE) > 0 Then
    Rup = Rup & " Paise "
    If Val(Left(FIGURE, 2)) 0 Then
    Rup = Rup & WORDs(Val(Left(FIGURE, 2)))
    ElseIf Val(Left(FIGURE, 2)) > 19 Then
    Rup = Rup & tens(Val(Left(FIGURE, 1)))
    Rup = Rup & WORDs(Val(Right(Left(FIGURE, 2), 1)))
    End If
    End If
    FIGURE = amt
    FIGURE = Format(FIGURE, "FIXED")
    End Function
    in this coding i want 0 gentrate as ZER its not coming its coming like 0 as 0 how to i get it

  49. I like information, you providing,, Further request you to send me detail formulas specially for the condition "IF".I think it will help in future.

  50. How you use percentage formula in Excel.

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