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

If asked what Microsoft Excel is about, what would be your answer? Right, it's all about storing and crunching numbers. You can use Excel to calculate percentages and compound interest, count and sum cells based on specific criteria, find average, and even get a sample deviation of a given set of values. All this can be done by using Excel formulas.

In this tutorial, we are going to learn the basics of creating and using formulas in Excel. And because one of the most efficient ways to learn is through practice, we will also discuss a number of formulas examples to make things easier to understand. Here's a list of topics we are going to cover:

In MS Excel, formulas are equations that perform various calculations in your worksheets. Though Microsoft has introduced a handful of new functions over the years, the concept of Excel spreadsheet formulas is the same in all versions of Excel 2016, Excel 2013, Excel 2010, Excel 2007 and lower.

- All Excel formulas begin with an
**equal sign**(=). - After the equal symbol, you enter either a
**calculation**or**function**. For example, to add up values in cells B1 through B5, you can either:- Type the entire equation:
`=B1+B2+B3+B4+B5`

- Use the SUM function:
`=SUM(B1:B5)`

- Type the entire equation:
- Press the Enter key to complete the formula. Done!

When you make a formula in Excel, you can use different elements to supply the source data to the formula and indicate what operators should be performed on those data. Depending on the formula type that you create, it can include any or all of the following parts:

- Constants - numbers or text values that you enter directly in a formula, like =2*3.
- Cell references - reference to a cell containing the value you want to use in your Excel formula, e.g.
`=SUM(A1, A2, B5)`

.To refer to data in two or more contiguous cells, use a

**range reference**like A1:A5. For example, to sum values in all cell between A1 and A5, inclusive, use this formula:

`=SUM(A1:A5)`

. - Names - defined name for a cell range, constant, table, or function, for example
`=SUM(my_name)`

. - Functions - predefined formulas in Excel that perform calculations using the values supplied in their arguments.
- Operators - special symbols that specify the type of operation or calculation to be performed.

To tell Microsoft Excel what type of operation you want to perform in a formula, you use special symbols that are technically called **operators**. There exist 4 types of operators in Excel:

- Arithmetic - to perform basic mathematical operations.
- Comparison (logical) - to compare values.
- Concatenation - to join text values into a single string.
- Reference - to make rages and separate arguments in Excel functions.

These operators are used to perform basic mathematical operations such as addition, subtraction, multiplication, and division.

Operator |
Meaning |
Formula example |

+ (plus sign) | Addition | `=A2+B2` |

- (minus sign) | Subtraction Negation (reversing the sign) |
`=A2-B2` `=-A2` (changes the sign of the value in A2) |

* (asterisk) | Multiplication | `=A2*B2` |

/ (forward slash) | Division | `=A2/B2` |

% (percent sign) | Percentage | `=A2*10%` (returns 10% of the value in A2) |

^ (caret) | Exponential (power of) | `=A2^3` (raises the number in A2 to the power of 3) |

For example, if you have an item price in cell A2 and VAT in cell B2, you can calculate the VAT amount by using the following percentage formula: `=A2*B2`

In Microsoft Excel formulas, *comparison*, or *logical*, *operators* are used to compare two values. The result of the comparison is always a logical value of TRUE or FALSE. The following logical operators are available in Excel:

Comparison operator |
Meaning |
Formula example |

= | Equal to | `=A2=B2` |

<> | Not equal to | `=A2<>B2` |

> | Greater than | `=A2>B2` |

< | Less than | `=A2<B2` |

>= | Greater than or equal to | `=A2>=B2` |

<= | Less than or equal to | `=A2<=B2` |

For example, formula =A1=B1 returns TRUE if cells A1 and B1 contain the same value (number, text or date), FALSE otherwise.

For more information and examples of using comparison operators in MS Excel formulas, please check out the following tutorial: Excel logical operators - equal to, not equal to, greater than, less than.

Text concatenation operator in Excel is the ampersand symbol (**&**). You can use it to join two or more text strings in a single string.

For example, if you have country codes in column A and telephone numbers in column B, you can use the following formula to get the telephone numbers combined with the country codes:

`=A1&" "&B1`

In the above formula, we concatenate a space " " in between to make the numbers better readable:

The same result can be achieved by using the CONCATENATE function, and the following tutorial explains all the details: How to combine text strings, cells and columns in Excel.

To supply rages to MS Excel formulas and separate arguments in Excel functions, the following operators are used.

**Colon (:)** - it is a **range** operator that allows you to make one reference for multiple cells located between 2 cells that you specify.

For example, range A1:A00 includes 100 cells from A1 through A100. To find an average of those 100 cells, you use the following formula: `=AVERAGE(A1:A00)`

You can also refer to the **entire column** (A:A) or the **entire row** (1:1). For example, the following formula finds the total of all numbers in column A: `=SUM(A:A)`

. Find more about whole-column and whole-row references.

**Comma (**,**) **- is used to separate arguments in Excel spreadsheet formulas. For example, the formula `=IF(A1>0, "good", "bad")`

reads as follows: if A1 is greater than zero, return "good", otherwise "bad".

`=IF(A1>0; "good"; "bad")`

.
So, if you are trying to make a formula in your worksheet, but Excel does not accept it and throws up an "invalid formula" error, go to your Regional Settings (*Control Panel >* *Region and Language* > *Additional Settings)* and check what symbol is set as **List Separator** there. It is that symbol that you need to use to separate arguments in your Excel formulas.

**Space** - it is an intersection operator that lets you get the cell(s) common to the two references that you specify. For example, if you a list of items in column A and some related data in other columns, you can get a value at the

intersection of a given column and row by using a formula like this: `=B3:D3 C2:C4`

For a real-life formula example, see how you can do two-way lookup in Excel by using named ranges & space operator.

Formulas that you create in your Excel spreadsheets can be simple or complex:

**Simple**Excel formulas perform just one mathematical operation, for example`=10*5`

or`=SUM(A1:A10)`

**Complex**(advanced) Excel formulas include more than one calculation, for example`=10*5+20`

or`=SUM(A1:A10)/2`

Further on in this tutorial, you will find the detailed steps for making both types of Excel spreadsheet formulas.

As already mentioned, any Excel formula starts with the equal sign (=). So, whatever formula you are going to write, begin by typing = either in the destination cell or in the Excel formula bar. And now, let's have a closer look at how you can make different formulas in Excel.

Although simple Excel formulas perform just one calculation, they can do this in many different ways. You can supply the source data as constants, cell references, or defined names, and perform calculations by using mathematical operators or Excel functions. For detailed steps, please see the following resources:

- Make a simple Excel formula by using constants and operators
- Write formulas using cell references
- Create an Excel formula by using defined names
- Make Excel formulas by using functions

When you have some experience with simple Excel formulas, you may want to perform several calculations within a single formula. And the following examples show how you can do this.

For a complex Excel formula to calculate correctly, certain operations must be performed before others. The default order of operations in Excel formulas is this:

- Mathematical operations enclosed in parenthesis
- Power of (exponential calculations)
- Multiplication and division, whichever comes first in a formula
- Addition and subtraction, whichever comes first in a formula

For example, you can use the following formulas to calculate the total and commission:

And now, let's break down these formulas to see how Microsoft Excel calculates them:

Total formula: `=$B2*$D2+$B2*$D2*$C2`

- 1st multiplication: $B2*$D2 (price*qty. = amount)
- 2
^{nd}and 3^{rd}multiplications: $B2*$D2*$C2 (price*qty.*VAT % = VAT amount) - Addition: amount + VAT amount = total

Commission formula: `=($B2*$D2+$B2*$D2*$C2)*10%`

To calculate the 10% commission, you need to multiply the total by 10%, so you enclose the previous calculation in brackets, and got the result you want.

Of course, nothing prevents you from multiplying the total already calculated in column E by 10%, in this case the formula would reduce to a simple calculation `=E2*10%`

. However, in large worksheets, it makes sense to write independently calculated formulas, so that removing a column with one formula wouldn't break the others.

In Microsoft Excel formulas, **nesting** one function within another means using one function as an argument of another function. In modern versions of Excel 2016, 2013, 2010 and 2010, you can use up to 64 nested functions. In older versions of Excel 2003 and lower, only up to 7 levels of functions are allowed.

Here is a very simple example of a nested Excel formula that includes the SUM function to find the total, and ROUND function to round that number to the nearest integer (0 decimal places):

`=ROUND(SUM(B2:B6),0)`

Of all Excel functions, IF is nested more often than all others. As you probably know, the IF function is used to evaluate a specified condition and return one value when condition is met, and another value when the condition is not met. However, quote often you have to deal with situations where there are more than two possible outcomes. And if this case, you can write several IF functions and nest them into each other:

For the detailed explanation of nested IF's syntax and advanced formula examples, please check out the following tutorial: Using nested IF functions in Excel.

Array formulas in Excel are advanced aerobatics. A single Excel array formula can perform thousands of calculations and replace hundreds of usual formulas. Learning array formulas certainly requires some time and effort, but it's worth it.

Since this tutorial is purposed for beginners, I won't intimidate you by the definitions of array constants and complex multi-line formulas. I'll show just one very simple example of an Excel array formula that demonstrates what they are capable for.

Supposing you have 2 columns of numbers, column A and B. And you want to know how many times column B is greater than or equal to column A when a value in column B is greater than 0.

This task requires comparing two ranges and you can do this by using the following array formula:

`=SUM((B2:B10>=A2:A10) * (B2:B10>0))`

To learn more about Excel array formulas, please see the following tutorials:

- Excel array formulas, functions and constants - explains the basics of array formulas and shows how to use array constants and array functions.
- Excel array formula examples for beginners and power users - 7 fascinating examples of advanced array formulas in Excel.

Although Microsoft Excel has hundreds of built in functions, you still may find yourself faced with a challenge for which no predefined Excel function exists. In this case, you can create that function yourself... or have somebody create it for you :)

Such custom functions are called **User Defined Functions** (UDFs), and they are especially useful for advanced mathematic or engineering calculations. Like macros, user defined functions are written in VBA (Visual Basic for Applications). As an example, you can review and download custom functions created by our team to count and sum cells by color.

There exist 3 types of cell references in Excel: absolute ($A$1), relative (A1) and mixed ($A1 or A$1). All three of the above references refer to the same cell, and the dollar sign ($) is used only for one purpose - it tells Microsoft Excel whether to change or not to change cell references when the formula is moved or copied to other cells.

**Absolute cell reference** ($A$1) - the $ sign before the row and column coordinates makes a reference static, and lets you copy a formula **without changing references**.

**Relative cell reference** (A1) - a cell reference with no $ sign changes based on relative position of rows and columns in a spreadsheet.

**Mixed cell reference** - can be of 2 types:

*Absolute column and relative row*($A1) - the $ sign in front of the column letter locks the reference to the specified column, so the column never changes. The relative row reference, without the dollar sign, changes depending on the row to which the formula is copied.*Relative column and absolute row*(A$1) - the row's reference locked by $ doesn't change, and the column's reference does.

The following image shows how different reference types work in practice.

For more information about Excel cell reference and more formula examples, please see Why use $ in Excel formulas - absolute and relative cell references.

Formulas in Excel are a powerful multi-faceted tool, and they can solve a great variety of tasks in your spreadsheets. Of course, learning various aspects of Microsoft Excel formulas and functions does take time, so you might feel there isn't enough time in the day to learn everything. Well, a good way to find more time is to save some time :)

- To toggle between absolute, relative and mixed references in a formula, use the F4 key as demonstrated in Switching between reference types in Excel.
- To
**view all formulas**on the sheet, click the**Show formulas**button on the*Formulas*tab >*Formula Auditing*group or press the Ctrl+~ shortcut. - To
**edit a formula**, press F2, or double click a cell, or click the formula bar. - To
**debug formulas**in Excel, select a formula part and press F9. This will let you see the actual values behind cell references. - To
**copy a formula to****all cells in a column**, enter the formula in the first cell, select that cell, and hover the cursor over the small square in bottom right corner until it changes to a black cross (which is called

the fill handle). Double click that cross, and you will get the formula copied through the entire column. - To
**convert formulas to values**, select all cells with formulas that you want to convert, press Ctrl+C to copy those formulas, then press Shift+F10, then press V, and then hit Enter. Shift + F10 + V is the shortcut for Excel's*Paste special - values only*. If you are not sure you will remember this shortcut, then simply press a usual shortcut for paste Ctrl+V, click the small arrow to the right of the*Paste*button to open the drop-down list, and select*Paste Values*. For more information, see How to replace formulas with their values in Excel.

Excel provides formulas for almost anything, and there exist tens or even hundreds of different functions in modern versions of Microsoft Excel. So, if you encounter a task for which you cannot work out a solution, most likely you are missing out on a formula that can do it for you. Before spending hours and hours on performing manual calculations, take a few minutes to review the following resources. It is a selection of the most popular MS Excel formulas with examples, grouped by categories.

Well, we seem to have finally got to the end. What was planned as a short Excel formula tutorial for beginners has nearly turned into a voluminous manual because there are so many different aspects of Excel formulas to cover. I am really thankful to everyone who has read this page to the end!

Excel formulas
CSV
Excel functions
Print
Vlookup in Excel
Merge data in Excel
SumIf
Excel CountIf
Excel Compare
Excel If statement
Excel Charts
Pivot Table
Updates
Excel conditional formatting
Excel formatting
Excel time
Excel duplicates
Excel date
Excel tips
Excel macro
Outlook
Google Sheets
Outlook duplicates
Outlook templates

## 126 Responses to "Microsoft Excel formulas with examples"

sumif

Hello,

can you plz send me a formula for the below example

An employee salary is 120000 so he will pay tax like

1- 5000 = 0 tax

2- 5001 - 12500 = 7500 x 2% = 150

3- 12501 - 100000 = 87500 x 10% = 8750

4- 20000 = 20000 x 20% = 4000

so the total is 0+150+8750+4000= 12900

waiting for your reply

thanks

Samimi

=IF(K1<5000,0,K1-5000)*2%-IF(K1<12500,0,K1-12500)*2%+IF(K1<12500,0,K1-12500)*10%+IF(K1100000 and Percentage will be variable 20%-10%

K1=120000

down four formula has been combined with + which is showing above

IF(K1<5000,0,K1-5000)*2%

IF(K1<12500,0,K1-12500)*2%

IF(K1<12500,0,K1-12500)*10%

IF(K1<100000,0,K1-100000)*10%

means if an employee salary is

1- up to 5000 so 0% tax

2- from 5001 up to 12500 2% tax

3- from 12501 up to 100000 10% tax

4- more than 100000 20% tax

This formula is reyaly work Great work

learn in excel formulas

Another comparison operator, that must be mentioned, is ”between”. Formula for interval between 4 and 7 is: AND(A1>4, A1<7)

Dr sir,I ask a reply my querry as follows:IF(A15800 & 300 if B1<5800.Pls let me know the formula.

Kind regds.

What is the two types of components of formula that start in Letter O?

Ipotse

Please Send All Formula use excel sheet.

i want know the all of excel formulas

how to use in excel 2 nos*2500=5000

Very good stuff. I have learnt a lot.

Thank you All

how do I enter a formula for the following

Column A $5,000

Column B gets 2500 Column C gets the difference I want Column d & E to calculate %. I also want to be able to change $ amount in B and have the $ amount and % automatically change based on whether I change $ or % amounts.

plz send all vlookup & Hlookup formula with example, and micro command from beginer

Phle ek kam tera basic clear kar. phir VBA me jana. Pagal

How to minus ex : 15% margin in investment amount

Need the excel formula

OBALE 45 86 95 98 98 422 45 98

ASALE 87 67 76 98 88 416 67 98

OPETO 56 34 32 43 67 232 32 67

ATWANI 88 76 78 87 76 405 76 88

32 98

please can someone solve for me this because these five students did the exam and these are their max. so what i need is can someone show me how to get MAX value,MIN value,AVERAGE value,POSITION value,GRADE value and RANK values. Thanks or your assistance in advance.

Hello!

i need some help

if i have total amount 1000 which include 17% tax i need the true amount so what was the formula.

hi.farhan.

try this formula.

=A1*17%+A1

pls i wish to know the formulas for business account.

I have a beginning balance column that I need to Name in another column. so if "Tom's" Beginning Balance of $410 (Column E), then column H needs to identify him on the Standard Plan

If Joe's Beginning Balance is $500 (Column E), then column H needs to identify him on the Enhanced Plan

Thank you

HI JRC.

TRY THIS.

=If(E1=410,"standard plan",IF(E1=500,"ENHANCED PLAN"))

hi. I have had a hard time making formula for the following problem in excel. can someone help?

please give me the true formula.

this is the problem.

if F15 is within 0.26-0.75 and H15 is above 0.20 the value returns to "retained"

if F15 is within 0.26-0.75 and H15 is below 0.20 the value returns to "revised"

if F15 is not within 0.26-0.75 and H15 is above 0.20 the value returns to "revised"

if F15 is not within 0.26-0.75 and H15 is below 0.20 the value returns to "rejected"

I will be glad to your right response. thank u.

This is very simple. Just try this =IF(AND(F15>=0.26,F150.2),"Retained")

=IF(AND(F15>=0.26,F15<=0.75,H15<0.2),"revised")

=IF(AND(OR(F150.75),H15>0.2),"revised")

=IF(AND(OR(F150.75),H15<0.2),"rejected")

If you are trying to make a nested formula for these situations then try this (since you haven't indicated whether the value of 0.20 is in above or below category, I have assumed it is above):

=IF((AND(F15>0.26,F15=0.20)="truetrue","retained",IF((AND(F15>0.26,F15=0.20)="falsefalse","rejected",IF(AND(F15>0.26,F15=0.20)=FALSE,"revised","")))

😁

=IF((AND(F15>0.26,F15=0.20)="truetrue","retained",IF((AND(F15>0.26,F15=0.20)="falsefalse","rejected",IF(AND(F15>0.26,F15=0.20)=FALSE,"revised","")))

I swear its glitching. Actual formula keeps changing.

=IF((AND(F15>0.26,F15=0.20)="truetrue","retained",IF((AND(F15>0.26,F15=0.20)="falsefalse","rejected",IF(AND(F15>0.26,F15=0.20)=FALSE,"revised","")))

Formula in the form of a self that comes in another cell by writing in a cell

I swear its glitching. Actual formula keeps changing.

Level 0 If % of marks secured is LESS 40%

Level 1 If % of marks secured is from 40% to 49.9%

Level 2 If % of marks secured is from 50% to 59.9%

Level 3 If % of marks secured is from60% to 69.9%

Level 4 If % of marks secured is from70% to 79.9%

Level 5 If % of marks secured is equal to 80% and above

FOR EX

PERCENTAGE 75 83 82 41 39

LEVELS

LEVELS HAVE TO DISPLAY in levels column

very nice teaching

Very nice formula of excel

Dr sir you hereby requested to please avail me the latest examples for Excel. It was helpful.

I want to get the total employee who has a salary of 1,000 - 5,000(example) how can i formulate it? thanks in advance!!

Hello Joseph,

You can use the countifs function for this.

=countifs(criteria_range,criteria,criteria_range,criteria)

=countifs(A1:A10,">=1000",A1:A10,"<=5000")

Where A1 to A10 is the range with employees salary

please send me vlookup formula and hlookup formula with example

Hi!

You can find lots of examples here:

* How to use HLOOKUP in Excel with formula examples

* Excel VLOOKUP tutorial with formula examples

I need to know how to: input numbers, each in its own cell.I have a formula which I execute in a cell. I make a PDF file for others to view.

I want to see the numbers that were used in the formula to be automatically inputted into a written formula.I want this formula to be written out and shown in a cell. This will show viewers the formula with numbers that was used in execution of the formula.

Hope you can help. Thanks.

Hi very nice technological and teaching Excel formula simple

If I want to add C1 & C3 and display the result in C3?

how do I add 10% to my price using the formula

Hi Gift,

The generic formula to increase an amount by percentage is this: = Amount * (1 + %)

To add 10%, multiply your price by (1+10%) or simply by 1.1. For example, if the price is in cell A1, the formula is =A1*1.1

For more information and formula examples, please see How to calculate percentage in Excel.

Hello everyone,

I need help with a formula, I'm trying to come up with a formula that will calculate in the same row two possible different operations.

For example B5-C5 or B5+D5 calculate the total of ether equation depending if it's a credit or debit. I don't know if I'm making myself clear. TIA

Due Credit Debit Balance

$99.27 $87.40 $11.87

Differentiate vividly the difference between The Two type of formulas in ms excel giving two examples

this is vary good formula for us. I understand that.....

Could anyone help me write a function or direct me to a resource that I can use to write:

A1 * (B1 or C1 when B1 or C1 is different from zero or different from 'blank')

The B1 or C1 values will be attributed from a pull down menu and it will be either B1 or C1)

Thanks a million!!!

I am having trouble figuring this one out. I'm trying to get I34=0 when cell F34=0 but when F34>160 I need it to put what is in Cell H34.

Hello, Carey,

you need to construct a simple nested IF formula in I34:

=IF(F34=0,0,IF(F34>160,H34,""))

I am working on splitting a track of land into parcels. The track of land has an amount money tied to it. Each parcel will be split from the larger whole based on acres. The money will then be split based on the acres of the parcels. Setting up the excel formulas isn't the problem. I seem to be ending up with more money than I started with. How is that possible? Is this a decimal issue? I end up with about $117 more than the whole started with.

Thanks, Marissa

How to count poor grade using count if function

I don't understand anything here

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

Please send me 2 example of each other

1 Multiplication

2 subtraction

3 Division

Plz help me fast please anyone tell me👱😂😂😭😒🤔🤔

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

Hello,

Please try the following formula:

=(1500*1000)/0.7

Hope it will help you.

Pls. help with a detailed example for ^ symbol

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

please create the simplest way how to calculate different calculations!

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

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

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.

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 .

fag

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

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

SIMPLER!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

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

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

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

please send me formula

please how do i calculate this in excel.

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

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

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.

Syam:

Enter this in an empty cell:

=B4*500

Actually I need help

So please help me

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

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

Tamal:

The formula looks as though it should be =SUM(B1:B5).

It will sum the values in cells B1 through B5.

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.

How to convert numbers into words in excell

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

Thank you

Eric:

Ablebits has an article as well as some code to convert numbers to words. Be sure to check out the comments for some fixes and modifications to enable the code to work with different currencies.

Here's the address:

https://www.ablebits.com/office-addins-blog/2013/08/29/convert-numbers-words-excel/

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.

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

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

Nice lessons, thanks alot

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

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

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.

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

Very usefull

Thank you anyway!!!

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

Formula of add A3 & D3 in G1

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

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)

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

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

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.

this many formulas how can i write in exam

hall today?

leave that one

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.

ok see you later

wait! wait! wait!

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?

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

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

Very good nice lesson

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?

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

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

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

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

what is the farmula for 87*10-34%

I like to study excel the practice. hi,

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

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

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

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

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

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

Is very good,thank you sir.

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

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.

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