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 on: Basic Excel formulas & functions with examples
by Svetlana Cheusheva, updated on
Comments page 13. Total comments: 413
what is the formula to remove the dashes from this number:
42-235-36180
Part No L5A L5B L5C L5D Total Loc
111086 9 9 L5A
141713 1 1 L5A
141755 24 36 30 30 120 L5A,L5B,L5C,L5D
146000 2 2 L5D
521219 12 6 18 L5C,L5D
HI
I had an requirement related to Excel formulas. If any one can help me out .Just have an try....
Part No L5A L5B L5C L5D Total Loc
111086 9 9 L5A
141713 1 1 L5A
141755 24 36 30 30 120 L5A,L5B,L5C,L5D
146000 2 2 L5D
521219 12 6 18 L5C,L5D
Here Loc column should be come from the excel formula. Here the concept is that column part no was residing in the different locations like L5A,L5B,L5C .....I need the Loc column value should be automatically come with the excel formula that each part will reside in different locations. Those locations has to be come with one formula for every part number. Please help me out in this.
formula for remaining days betwwen today and various Expiry dates of various products i.e in coloumn A3 I enter to today date and in other rows we mentioned expiry date of varoius products.
How to calculate days until expiration.
In cell A1 enter expiration date.
In cell B1 enter "=A1-TODAY()". This will display a number.
If the data has already passed, the number will be negative.
Remember to format cells as dates if you need to show a date.
You may also want to checkout EOMONTH function.
To create expiration date.
Enter date in cell C1.
In cell D1 enter "=C1+90". This will create a date 90 days in the future.
formula for remaining days betwwen today and various Expiry dates of various products
if cell name (A1) in figure are 456, i want in A2 is 456/3
how its possible
note A1 cell (456) is total of sum cell, its change many time
Thanks Sharing this Formulas, it's helpful for me and others...
Very useful fa beginners tqsm but will updating more formulas fa all kinds of users
how can i put the amount on another sheet
Date deposit withdraw balance 01/10 12000 Nil. Nil. 03/01 Nil. 5000. _ what is the formula
thankyou sir......it is really a useful formula....
Pls tell me text formulas for multiple cell
Please am just a beginer in Excel
can i meet you on a prevate tutor?
On ur convinient time pls?
Good knowledge, please send excel formulas.
can anyone give me formula for automatic grace marks for student who get the mark between 30 to 35.if passing mark is 35.
condition is grace marks can be given only in three subject.
please reply as soon as possible.
thanks in advance
can anyone give me formula for automatic grace marks for student who get the mark between 30 to 35.if passing mark is 35.
condition is grace marks can be given only in three subject.
can anyone give me a formula for getting an approved "A" result of the submittal.
Example:
A1 = C (Revised and resubmit)
C1 = B (approved as noted)
D1 = A (approved)
I need an answer which ever revision is the latest.
Thank you in Advance
Jean
its very informative and Thanx for this ..
any body have any other formula regarding excel kindly mail me or whatsapp
It's was to help ful to me
how to fetch one table to another table data
Say
buyer X received 123 pcs from unit 1
buyer X received 500 pcs from unit 2
buyer X received 280 pcs from unit 3
buyer y received 123 pcs from unit 3
buyer y received 123 pcs from unit 1
buyer Z received 123 pcs from unit 2
buyer Z received 123 pcs from unit 1
Please put formula who I calculate buyer wise and unit wise received total qty
Give me the formula name for
C3*C4%+C3
Very good
Can u teach us how to make general ledger tria balance
SR NO FORUMAULA
IF I HAVE TWO COLOMS A & B WHERE "A" HAS MATERIAL AND "B" HAS QTY. AND DON'T WANT TO FILTER TO COUNT PARTICULAR QTY FOR MATERIAL ,SO I WILL DO WORK IN A NEW COLOM "D" AS MATERIAL AND "E" QTY AND WHAT I NEED HELP THAT AUTOMATICALLY QTY ADD UP IN COLOM "D" & "E" WHEN I WILL DO ENTRY IN "A" & "B"..PLEASE REVERT ME IF YOU NEED SCREEN SHOT OF MY WORK...
nice explanation
if Total cost is 10000. i want to calculate what is the value which includes 12% in 10000. Tell me the formula pl.
ex: TOTAL COST A1
PRICE :=A1*100/112
REALLY VERY HELPFUL THANKU
=num2text FIGURES TO WORDS
Hello,
I have been asked to extract the number from the following list without using MID as this only works when all the results are the same type.
TX TO 2014016 CHG ORG
TX TO 1832298CHG ORG DEN
TX TO 1854600 CHG ORG
TX TO 1971447
TX TO 1980547 CHG ORG
Any help is appreciated
Hello,
If you need to avoid using the MID function to fulfill your task, then I can recommend you to try extracting numbers from your list of data with the help of the Extract Text tool.
I sew and i believe about all form A.I.A
Do data jaise colume A or colume B dono ka data colume A me Lana hai to kon SA formula use hoga
K L
COLUMN COLUMN
R M =CONCATENATE(K15," ",L15)
= R M
= " " STANDS FOR SPACE
Qut Amount Discount Amount
2 300 20% ===
THANKS YOU
Sum (no1, no 2)
if sheet 1 - particular cell value is visible in sheet 2 - What is the formula for that?
Deduction under VI A in incometax calulation is 150000 but Candidate Have Deduction more then 150000 or Less than 150000 we want to rebate only 150000 what is the formula in exel
Sorry, my typing was inaccurate, the first column should be Monthly Basic Salary x 2.75% with values that ranges from P10,000 to P40,000. The second column should be Monthly Premium with values P275, P275.02-P1,099.99 & P1,100.
Hope this is clear now.
Thanks
Hello,
Supposing that your table starts from A1, please try to do the following:
1. Enter P10,000.00 in cell A2;
2. Enter the following formula in cell B2:
=A2*2.75%
3. Select the cells with your data and drag the fill handle (a small square at the lower right-hand corner of the selected cell) down.
Hope it will help you.
Hi, can you help me create a formula for below table? I have tried but there is lacking in result for the condition of P40,000 and above.
Monthly Basic Monthly
Salary x 2.75% Premium
P10,000.00 & below P275
P10,000.01-P39,999.99 P275.02-P1,099.99
P40,000.00 & above P1,100.00
Thank you in advance.
explain excel
Hi, I need to calculate % discount in my spreadsheet, I need a kind assistance. Thanks.
Hello,
For me to understand the problem better, please send me a small sample workbook with your source data and the result you expect to get to support@ablebits.com. Please don't worry if you have confidential information there, we never disclose the data we get from our customers and delete it as soon as the problem is resolved.
Please also don't forget to include the link to this comment into your email.
I'll look into your task and try to help.
dear concern:
in excel i cant correct the below function .please help me
04KRKKRK i want to delete 04KRK AD ADD 04BNUKRK at whole list.plz
04KRKKRK
04KRKKRK
04KRKKRK
04KRKKRK
up to 1000
A B C D
04KRKKRK =LEFT(3,A1) YOURWRLD =B1&""&C1 (COPY THAT IN ALL CELL)
04KRKKRK
04KRKKRK
HELLO..can anyone help me using formulas in payroll?
heres the data summary example:
name rate/mo deductions total net
sss phic hdmf deductions pay
1) A 13000 1200 125 500 1825 11175
2) B 25000 1700 125 1000 2825 22175
what i want is in a certain payslip i just encode #1 then all the details will come out in just one click...is it possible?
thank u for the guidance.
Hello,
For me to understand the problem better, please send me a small sample workbook with your source data and the result you expect to get to support@ablebits.com. Please don't worry if you have confidential information there, we never disclose the data we get from our customers and delete it as soon as the problem is resolved.
Please also don't forget to include the link to this comment into your email.
I'll look into your task and try to help.
At first you must have the time of particular date then can find through apply below formula.
=int(time-date)
Hello,
Can anyone tell me how can I calculate elapsed days if I have a date & time in place.
such as I want to calculate how much time has been elapsed till this time from the given date & time.
2017-11-13 19:35:19
Hello,
Please try the following formula:
=DATEDIF(A1,IF(TIME(HOUR(A1),MINUTE(A1), SECOND(A1))> TIME(HOUR(NOW()),MINUTE(NOW()),SECOND(NOW())),NOW()-1,NOW()),"D")&" days "&HOUR((1-VALUE(TIME(HOUR(A1),MINUTE(A1), SECOND(A1))))+ VALUE(TIME(HOUR(NOW()), MINUTE(NOW()), SECOND(NOW()))))&" hours "&MINUTE((1-VALUE(TIME(HOUR(A1),MINUTE(A1),SECOND(A1))))+ VALUE(TIME(HOUR(NOW()),MINUTE(NOW()),SECOND(NOW()))))&" minutes "&SECOND((1-VALUE(TIME(HOUR(A1), MINUTE(A1), SECOND(A1))))+ VALUE(TIME(HOUR(NOW()), MINUTE(NOW()), SECOND(NOW()))))&" seconds"
Hope it will help you.
Great Dear But it is Not Automatic I have to refresh then it will work please do work for this Automatic Running line Hours Mints and secound
Please what does this formula mean in a sentence form?
=RANK(A2,A$2:A$8)&MID("thstndrdth",MIN(9,2*RIGHT(RANK(A2,A$2:A$8))*(MOD(RANK(A2,A$2:A$8)-11,100)>2)+1),2)
Hi, I want to know what vlookup can use in "if". Means it the condition is true then vlookup will run.
Hi Babu,
You can nest a Vlookup formula in the value_if_true argument of the IF function like this:
=IF(logical_test, VLOOKUP(...), "")
Plese send the transfer to number in word formula
good
=IF(COUNTIF(A2:E2,"0")=5, "STRONG", IF(COUNTIF(A2:E2,"0")=4,"GOOD",IF(COUNTIF(A2:E2,"0")=3, "POSITIVE","WEAK")))