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

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

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

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

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

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

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

  7. Very good nice lesson

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

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

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

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

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

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

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

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

  16. Formula of add A3 & D3 in G1

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

  18. Thank you anyway!!!

  19. Very usefull

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

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

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

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

  24. Nice lessons, thanks alot

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

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

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

  28. How to convert numbers into words in excell

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

    Thank you

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

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

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

  32. Please Help me to Solve this

    I am entering 10 in cell B4 after entering the value the result should be 500*10bin the B4.

    1. Syam:
      Enter this in an empty cell:
      =B4*500

  33. please how do i calculate this in excel.

    0.98*In(1/0.98) + 0.02*In(1/0.02)

    1. Umar:
      If I'm reading this right the method is:
      In the cell you want to display the result enter
      =0.98*(1/0.98)+0.02*(1/0.02)
      Take the "In" out of the formula.
      If you need to display it in the result you can concatenate the "In" to the result with this formula
      =0.98*(1/0.98)+0.02*(1/0.02)&" In". Not the space before the "In".
      If you're trying to use the natural log function in Excel its symbol is LN and the formula looks like:
      =0.98*(LN(1/0.98))+(0.02*LN((1/0.02)))

  34. please send me formula

  35. I have sheet under
    BEFORE MRP VALUE
    1500
    1200
    900
    800
    700
    1800
    500
    how to Calculate 1000 Rupees Above 12% and below 1000 Rupees is 5% .

    1. Shridhar:
      Will this work?
      Where "Before MRP Value" is in column A.
      The sample is in cell A5 the formula looks like this:
      =IF(A5<=1000,A5*0.05,A5*0.12)
      It says, "If the value in A5 is less than or equal to 1000 then multiply it times 5%, otherwise multiply it times 12%."

  36. how to Calculate Gst Percentage Amount in below 1000 rupees and Above 1000 rupees ?
    per example 900 rupees is 5 % gst and 1000 rupees is 12% gst

  37. SIMPLER!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

  38. FORMULAR FOR MEAN IN CELL 3, IF CELL 1 = 20000, CELL 2=80000

  39. Al Wukair 3.50 Al Wukair 3.00 Al Wukair 2.00 Al Wukair 6.00 Al Jeryan 3.00 Al Jeryan 3.00 Al Jeryan 3.00

    above data is in horizontal i.e. in rows. number defined are overtime hours. how to sum for each location.

    advance thanks.
    amit lalchand kamwani

  40. fag

  41. can you please send me a formula for the below,
    Credit card outstanding is 1000 usd (for example) he/she have to pay minimum bill 50 USD or 2% whichever is higher. please need your cooperation .

  42. i have a sheet as under:
    A B C
    Vehicle Petrol Diesel
    700 60 0
    800 80 0
    345 0 90
    700 50 0
    800 75 0
    500 0 50
    345 0 80
    700 40

    i want all values of 700
    Vehicle Petrol
    e.g: 700 60
    50
    40
    Please what kind of formula can solve my this problem

    1. Hello, Saqib,

      If your data range is A1:C9, please enter 700 in cell E2, paste the following array formula in the adjacent cell (F2) and press Ctrl + Shift + Enter to complete it:

      =IFERROR(INDEX($B$2:$B$9,SMALL(IF($E$2=$A$2:$A$9,ROW($B$2:$B$9)-1,""),ROW(A1))),"")

      Then copy the formula down along column F to see all the matching values for Vehicle 700.

      You can find more details how to Vlookup to return multiple matches in this blog post.

      Hope this information will be helpful for you.

  43. (2947552.44+10%*0.05%+12%+1)/63.10 formula kese lagau

  44. please create the simplest way how to calculate different calculations!

  45. well ive gotten the needed basics in Excel and congratulate the examples,formula etc,thanks Google.

  46. Pls. help with a detailed example for ^ symbol

  47. Hello,

    can you plz send me a formula for the below:-
    i have purchased Atta 1500 kgs for 5029 persons, scale of atta per man is 0.700 gm, i want to know how many persons are covered from total persons 5029

  48. what is the formula for this in Ms exel "(8.3*10^3)/9"

    1. Please send me 2 example of each other
      1 Multiplication
      2 subtraction
      3 Division
      Plz help me fast please anyone tell me???????

  49. I don't understand anything here

  50. How to count poor grade using count if function

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