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

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

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

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

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

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

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

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

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

  9. How to sum of put Rs sign Amounts

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

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

  12. Is very good,thank you sir.

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

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

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

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

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

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

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

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

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

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

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

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

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

  26. Very good nice lesson

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

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

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

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

  31. How can I write an average function using two columns example I what to find the average of column e7 to e55 and I 7 to i 55. both columns are figure to get one average.

  32. if i want to calculate 87% of 750.00,what formula will i use please...

  33. Dear Sir,
    Pelase suggest me the formula for:
    suppose
    1) 90 - 100% 10 point
    2) 80-90% 09 point
    3) 70- 80% 08 point
    3) 70- 80% 07 point
    4) upto 59% 06 point

    in a 10 point scale

  34. =Countif(Reqs!B1:B,"Name"+(Reqs!H1:H,"Yes"))

    Obviously this is wrong but im not experienced enough to correct it.
    Basically i have column B with a name And Column H with either "Yes" or Blank.
    I need to write a formula for if theres The name and Yes in column H. it equals 1 on a different sheet.
    Reqs is the tab columb B is the names and H is Yes or blank
    Any advice?
    Thanks in advance.

    1. If you only wanted to count how many "YES", just type =COUNTIF(Reqs!H1:H1000,"YES), but if you want to count if column be has name =COUNTA(Reqs!B1:B1000)

  35. Formula of add A3 & D3 in G1

  36. What is the function FPPRA calculating? Meaning, how is the result of (d,j) calculated?

  37. Thank you anyway!!!

  38. Very usefull

  39. what shall i need to do for assigning work in excel. for eg. 2000 count has to be assigned to 9 people,each person has to get the same count

  40. Let us suppose for a full 3 trip the amount to be paid is Rs-53 than what will be calculation if it is a partial trip as per below

    Partial Trip Deduction in amount
    86-95% 15%
    76-85% 30%
    61-75% 50%
    51-60% 60%
    26-50% 80%
    0-25% 100%

    in such case which excel formulae can be used.

  41. In exel
    A4=100%
    B4=100%
    C4=100%

    The condition is, if any 1 of the 3 is 100% & above, reward is 1000/-, if any 2 of the 3 are 100% & above, reward is 3000/- and if all the 3 are 100% & above reward is 6000/- how to write a formula

  42. I WANT WRITE TWO OR THREE NAMES ON A SHEET IN COLUMN A. I WANT TO KNOW THAT HOW TO CALCULATE THE NAME.

  43. Nice lessons, thanks alot

  44. may you please help.how can learn how to publish the all formulas so that i can learn the basis

  45. May you please help. how can I create a formula to get a total percentage mark in the following example, 50/80 contributes 75%, while 30/80 contributes 25% to the total mark. I am a beginner

  46. How can we assign values to variables so that they can be used in formulaes.like a=2000
    B=30000 and write a and b or other variables in excel and perform mathematical operations.

  47. How to convert numbers into words in excell

    As in P 500.30 to Five Hundred Pesos and Thirty Centavos Only

    Thank you

  48. Iam facing a problem in excel, I have two excel sheets column 1 in both sheets having same data but small variation like product name in one sheet Q18nuxa2- lhj and in other sheet q18nux -lhf but I want replace total data in column 1 of sheet1 with sheet 2 data. Any formula or shortcut keys i have a bulk data . so please help me any tips.

  49. What is the correct formulae or function of @SUM(B1::B5)

    1. Tamal:
      The formula looks as though it should be =SUM(B1:B5).
      It will sum the values in cells B1 through B5.

  50. Actually I need help
    So please help me

    1. If A1+C1+E1 same more row ,but how I want sum ,I use which formula,if I want same
      =A1+C1+E1+G1 so many times give

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