Comments on: Microsoft Excel formulas with examples

Can Microsoft Excel formulas be easy to learn? Yep! This tutorial explains the very basics of Excel formulas for beginners, with detailed steps on how to write and use them. It also provides a number of advanced formula examples for experienced users. You will be amazed how simple creating formulas in Excel actually is. Continue reading →

Comments page 2. Total comments: 204

  1. I'm trying to write a formula that will solve this equation for "b" but I don't know how to do it. I've tried several different ways but nothing will give me the correct answer. Please help!
    35 = -65.2*0.75+b

  2. Please I what to understand the meaning of cell in Microsoft Excel

  3. Hi, cell A1 has a number like 725000, I need a result in cell B1:

    725,000 minus 600,000 = 125,000 *10% =12500 & plus 10,000 = 22500 result should be 22,500 in cell B1

  4. Is there a way to do tan-1 (the -1 is in superscript) calculations in excel?

  5. i have a problem my work is on printing large Lonas
    anyway how can i make a calculation to calculate the meter square of any product by only putting the price

  6. How would I calculate this equation in terms of x and y; when X=1(C5) and Y=3(C6)

    4 + y/(2x+y)sqrt 2 + 12

    (The 2x+y is in parenthesis but then squared but didn’t know how to type that here.

    I just need a formula to get the correct answer. I’ve tried several different ways and I keep getting the incorrect answer.

    1. Hello!
      You did not write what result you wanted to get. But I think this formula will work for you -

      =4+C6/(2*C5+C6)^2+12

  7. how to convert this 2.1291912051718E-87 to number in excel

  8. I don't really know, but near the top of the page there are two spots that talk about "rages" is that a typo?

    **Reference - to make rages and separate arguments in Excel functions.**

    1. Thank you, Ebhe! That's definitely a typo - fixed.

  9. What is Excel formula for Beta Distribution. Can I solve Beta distribution by using scientific calculator or Excel workbook just by using +,- * / and ^ and Factorial.
    Or I will have to learn programming language ?
    I know that Beta distribution can be calculated by using Excel , but I want to solve just by using Plus, Minus, multiplication, Division, Power ,log and Factorial.
    Thanks

  10. Thank you I'm practising

  11. Nice piece of work. Thank you.

  12. I want to your suggestions and support...really appreciate the help..and I want to learn mis excel

  13. Hi - I'm looking for an equation, that has 2 parts to it.
    The information is dates, in columns, that are specific to a row (a person's name).
    I want to have an equation that can gather all the dates for that row/person and have it embedded in another cell, to be used for another purpose. With that cell where the dates are embedded, I would like to be able to do a sort function. I'm thinking that I can use the sort feature, but am not sure.

    I will have multiple rows of information, and need to be able to create a sort.

    Thanks - Dewey

  14. How do i make excel sheet retain ratio inputs e.g
    1:10, 1:110 inside excel cells

  15. Where can I get full tutorials on how to use MS Excel

  16. think I ave understanded

  17. The formula means that if the code entered in cell C5 is equal to cell A14, cell D5 will indicate Baguio, if equal to cell A15, cell D5 will indicate Davao, if equal to cell A16, cell D5 will indicate Cebu...

    Can someone help me with this? I need to know what formula should i use... Please...

  18. i want to one request
    both are sheet same discerption i have updated first sheet name received quantity in second sheet we have issued in multiple quantity in same description .
    i want required in the first sheet less the quantity in formula which formula pleas let me now

    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. Give an example of the source data and the expected result.
      It’ll help me understand it better and find a solution for you.

  19. Very bad explained

  20. what does this symbol mean - "*:*"

    For example - =COUNTIFS('SCHEDULE '!K:K,"*:*",'SCHEDULE '!$A:$A,$B$78)

    1. Hi Sam,

      In Excel, an asterisk (*) is a wildcard that represents any sequence of characters. In your case, "*:*" will match any cell that contains a colon (:) in any position.

      For more information, please see Using wildcard characters in Excel

  21. Hello please could you tell me what a | (pipe) does in formulas?

  22. like this

    Colum C1 682728,659223,449369
    Colum C2 329452,856318,516020
    Colum C3 785713,3600088
    Colum C4 711182,25525

    how we can select the rang in this formula
    =ISNUMBER(FIND(C4,A1,1))

  23. if in Colum A1 4545,4815,8899,2288,123

    an in Colum C4 4815
    how we can apply a formula in the next Colum D4 ............ to find the value 4815 for Colum A1

    1. Hello!
      Could you please describe it in more detail? What result do you want to get?
      To find out that C4 is found in A1, we need the formula

      =ISNUMBER(FIND(C4,A1,1))

      1. if multiple Colum are given how we can apply a formula with multiple rang formula

  24. Basic DA Total PF
    11500 5495 16995 12% (PF always be cut on 15000, not on total)
    than what is the formula

  25. Sir,
    I dont know how to put formula....
    if basic + DA is upto 15000 then PF will be 12% and if more than 15000 it will also be 12%
    sir, what will be the formula in xls

    1. Hello!
      I’m sorry but your task is not entirely clear to me. You have the result of fulfilling any condition - 12%.
      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.

  26. HI,

    i need a formula to remove kilogram in tons in excel .

    Example-
    I brought an Item weight off 26000 tons and i need to remove 5 kilograms from each ton.

  27. Hi,
    I have a question said to me during my friend interview about Excel, the interviewer asked him " Which type of Excel formula do you use?"
    Honestly, my friend didn't answer that question and subsequently he missed the job.

    So what is the correct answer for questions like that.

    Best regards

  28. can u help me how create a formula for below value
    Cell A1 value = -24
    cell b1 value = 4
    how to calculate the differential between these to values

  29. How to sum of put Rs sign Amounts

  30. Great Svetalana,
    I am always a fan of your enlightened articles, your explanation is so amazing. BTW I have always been confused about the absolute reference but your team opens my brain about the absolute reference that how to put this in the formula and show the result. In the future, I will use your articles for teaching to students so that they grasp the knowledge about excel. Thanking you for the great explanation.

    i want to article about speedometer charts pls can you help me.

    Thanks
    Laxman

  31. can you please send me a formula for the below using macro excel
    (A|B)&(C|D)
    (A&B)&(C&D)
    (A&B)|(C&D)
    (A|B)&(C|D)&E
    (A|B)&(C|D)|E

    1. Hello Gerald!
      Your description of the problem is very short, so it’s hard to advise you something. For me to be able to help you better, please describe your task in more detail. It’ll help me understand it better and find a solution for you. Thank you.

  32. Is very good,thank you sir.

  33. =REPLACE(A:A,53,0,B:B)=REPLACE(A:A,113,0,B:B)
    its wrong and not working.but i share do you understand what i want...
    i want to add two REPLACE Formula in one cell!and i have some data in lines so i want to change using this formula.Please help me and tell me if it possible?

  34. I want find the min from row x to row x -20
    Is there any formula for cell reference?
    EX Cell = column(row) which numbers of row and column are created by other formula
    A22 = A(x-5) with x = 27 created from other formula

  35. ANYONE CAN HELP ME WITH FORMULA IN IF STATEMENT
    FOR EXAMPLE IF THE VALUE OF FIRST CELL IS EQUAL TO VALUE OF 2ND CELL THEN 3RD CELL MINUS 4TH CELL ELSE 5TH CELL VALUE

  36. if code starts with 4-fu in ACell than its B cells should be 4-pcs
    4-ccs
    5-co
    Stitching charges
    Stitch - OH
    plz suggest me a formula for this

  37. FILE A SAVED AS GIRL.XLSX
    DATE ADMIT NAMES ENG SCORE ECO SCORE MATHSCORE PHYSCORE TOTAL AVE
    Saturday 4th February 2006 JAMES 78 83 67 63 291 2.91
    Saturday 22nd August 2015 JOHN 98 82 89 82 351 3.51
    Saturday 10th August 2013 EMMA 67 75 47 89 278 2.78

    FILE A SAVED AS BOY.XLSX
    DATE ADMIT NAMES ENG SCORE ECO SCORE MATHSCORE PHYSCORE TOTAL AVE
    JAMES 78 83 67 63
    Saturday 22nd August 2015 JOHN 98 82 89 82 351 3.51
    EMMA 67 75 47 89

    IF ANY ROW IN FILE 1 GIRL.XLSX MATCHES ANY ROW IN BOY.XLSX COPY DATEADMIN
    FROM GIRL.XLSX TO DATE ROW IN FILE BOY.XLSX

    AN EXAMPLE JOHNS RECORD MATCHES AND IT WAS AUTOMATICALLY COPIED
    FROM GIRL.XLSX TO BOY.XLSX

  38. COMPARING SHEETS IN DIFFERENT FILES FOR A RESULT
    FILE1 SAVED AS GIRL.xlsx FILE2 SAVED AS BOY.xlsx
    EACH CELL CONTAINS EACH CELL CONTAINS
    COLUMN DATES A B C D E STUDENT ID# DATES A B C D E STUDENT ID#
    1 4TH A.19 1 2 3 4 5 2356 ?? 1 2 3 4 5 ??
    2 12TH J. 19 3 4 3 7 10 3468 ?? 2 5 8 2 9 ??
    2 29TH M, 19 3 4 3 7 10 2478 ?? 3 4 3 7 10 ??

    MY QUESTION
    IF ROW 1 IN FILENAME GIRL MATCHES ANY ROW IN FILE NAME BOY COPY DATES TO DATE AND STUDENT ID TO STUDENT ID
    please i need the formula. i have over 47000 rows in each file to update and tired of entering this one by one because i know there must be a formula

  39. I like to study excel the practice. hi,

  40. what is the farmula for 87*10-34%

  41. Hello,
    I have a formula in my excel to show quantity shipped or in backordered but this only works when the total qty is either shipped or not. As you can see not partials are been taking into account. See existing formula
    IF(A22="","",IF(B22="","BO",IF(B22="-","SHIPPED","")))

    I would like to add or have the formula to calculate the barkorder left
    Column A is 20 and when it changed to 14 I would like to have this formula to say or changed to 6 ON BACK ORDER
    Can you assist me with this ? I appreciate your help

  42. Trying to figure out how to make a formula for the following:
    Column B Cells input will range from 1 to 50
    Column C will be total points based on Column B input.
    Example 1 = 200, 2 = 98, 3 = 96 and so on.
    So it would look like this:
    Driver Qualifying Points
    Name 1 200
    Name 2 198

  43. BASIC MATHERMATICS OPERATORS ARE OPERATORS THAT WE USE IN OUR DAILY LIFE

  44. every first 3kg = 45 dollars
    after 3kg and every .00001 to 1kg= ill add 15 dollars
    for example
    3.01 = 45 (first 3kg) + 15 (.01kg=will become 1kg)= 60 dollars
    11.09 = 45(first 3 kg) + 15*9 (1+1+1+1+1+1+1+1+(.09=1kg) = 180 dollars

  45. If yearly instalmet Rs.1000/- for 5 year and interest rate is 5%.What will be formula for calculate maturity value for 5 or any year on yearly compounding basis?

  46. Very good nice lesson

  47. 1002+6=(1003-1008).i wont this method formula

  48. What formula will I use to multiple the value in cell A1 on the current worksheet by the value in cell A1 on sheet2

  49. HI,
    I AM GIVING YOU AN EXCEL SHEET. JUST HELP ME
    28735 14/03/19 HOT MILK 1 Rs 40.00 Rs 40.00 #309
    28740 14/03/19 MUTTON CURRY 1 Rs 255.00 Rs 255.00 #215
    28740 14/03/19 KADHAI PANEER 1 Rs 185.00 Rs 185.00 #215
    28749 14/03/19 HOT MILK 1 Rs 40.00 Rs 40.00 #109
    79303 14/03/19 M/S T-UP 1 Rs 60.00 Rs 60.00 #106
    36598 14/03/19 GOBHI PARATHA 3 Rs 100.00 Rs 300.00 #004
    36598 14/03/19 IDLI 2 Rs 75.00 Rs 150.00 #004
    36598 14/03/19 APPLE 2 Rs 25.00 Rs 50.00 #004
    36598 14/03/19 HOT MILK 1 Rs 40.00 Rs 40.00 #004
    36664 14/03/19 IDLI 1 Rs 75.00 Rs 75.00 #004
    36674 14/03/19 CHICKEN HAKKA NOODLE 1 Rs 185.00 Rs 185.00 #004
    36690 15/03/19 HOT MILK 1 Rs 40.00 Rs 40.00 #004
    79325 15/03/19 EGG CURRY 1 Rs 150.00 Rs 150.00 #206
    36755 15/03/19 BANANA MILK SHAKE 1 Rs 135.00 Rs 135.00 #004
    36686 15/03/19 BANANA 2 Rs 15.00 Rs 30.00 #004
    36756 15/03/19 ONION PAKODA 3 Rs 150.00 Rs 450.00 #004
    36762 15/03/19 VEG HAKKA NOODLE 1 Rs 140.00 Rs 140.00 #004
    28560 15/03/19 EGG ROLL 1 Rs 115.00 Rs 115.00 #206
    28554 15/03/19 P/A JUICE 1 Rs 150.00 Rs 150.00 #103
    28558 15/03/19 KAJU FRY 1 Rs 200.00 Rs 200.00 #106
    28558 15/03/19 EGG ROLL 1 Rs 115.00 Rs 115.00 #106
    28504 15/03/19 CHICKEN KASSA 1 Rs 245.00 Rs 245.00 #106
    36768 16/03/19 APPLE 2 Rs 25.00 Rs 50.00 #004

    NOW MY QUESTION IS WHAT WILL BE THE FORMULA OF A ITEM LIKE APPLE AFTER FEW DAYS LATER HOW THE RATE WILL COME AUTOMATICALLY?

  50. this many formulas how can i write in exam
    hall today?

    1. leave that one

      1. it carries 4 marks how can i leave that one and the exam is 60 only and duration is 2 hours but we get three hours and this type of question we cannot ask any one cause it is very big answer.

        1. ok see you later

          1. wait! wait! wait!

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