Microsoft Excel for PC Logo

Related Topics:

Posted on Jun 25, 2009
Answered

Sir i want to know about excel formulas please give me. my email.add. [email protected]

Answer This Question

1 Answer

Anonymous

Level 1:

An expert who has achieved level 1.

  • Contributor 1 Answer
  • Posted on Jun 25, 2009
Anonymous
Contributor
Level 1:

An expert who has achieved level 1.

Joined: Jun 25, 2009
Answers
1
Questions
0
Helped
176
Points
3

How can we do vlookup two sheet on excle?

E.g

Sheet1 Sheet2
Class Marks

here there are two types of Sheets.If i want to combiend two sheet via vlookup.could you teach me what should do i for same ASAP.

thaks.

Add Your Answer

×

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

0helpful
1answer

How to Add Month To Date Excel?
You can use the EDATE function to quickly add or subtract months from a date. The EDATE function requires two arguments: the start date and the number of months that you want to add or subtract. To subtract months, enter a negative number as the second argument. For example, =EDATE("9/15/19",-5) returns 4/15/19.

Add or subtract dates - Microsoft Support

and

Excel Add Months to Date - Corporate Finance Institute

 https://corporatefinanceinstitute.com > Resources
Nov 24, 2022 - Step 2: Use the =EDATE(C3,C5) formula to add the number of specified months to the start date. Where cell C3 is equal to today's date [the TODAY ...

How to Add Months to Date in Excel (Easy Formula)

 https://trumpexcel.com > add-months-to-date-excel
Add Months to a Date · start_date - the date for which you want to get a certain number of months before or after it · months - the number of months before or ...

Add months to date - Excel formula ' Exceljet

https://exceljet.net > Formulas
To add a given number of years to a date, you can use the EDATE function. In the example shown, the formula in D5 is: =EDATE(B5,C5)
Read full answer
Feb 07, 2023 • Computers & Internet
1helpful
2answers

What are the formulas in grading the grades uisng microsoft excel

Formulas are used to specify calculations based on values in designated cells. Excel supports basic calculations as well as statistical, trigonometric and other specialized functions.

Formulas used in Excel must follow a certain syntax.

  1. All formulas begin with an equals sign (=).
  2. Some formulas use operands such as +,-, *,/ for addition, subtraction, multiplication or division.
    For example, the formula =A1+A2+A3 would add the contents of cells A1, A2 and A3.
  3. Other formulas refer to different functions such as SUM, AVERAGE and others.
    For example, the formula =SUM(A1:A3) would add the contents for the range A1 through A3.
  4. Formulas can be combined with operands.
    For example, the formula =10*SUM(A1:A3) would add the contents cells A1 through A3 and multiply them by 10.
  5. Functions can be nested within each other.
    For example, the formula =SQRT(10*SUM(A1:A3)) would take the square root of ten times the sum of cells A1 through A3. When functions are nested, it is important that the number of left parentheses match the number of right parentheses.
Read full answer
Aug 19, 2011 • Microsoft EXCEL 2004 for Mac
0helpful
1answer

HI SIR, I WANT EXCEL ALL FORMULAS PLZ GIVE. MY CELL NO IS 9773542151
This is the link for excel formulaes on microsoft website http://office.microsoft.com/en-us/excel/HP052001271033.aspx
Read full answer
Jun 21, 2009 • Microsoft Excel for PC
1helpful
2answers

Writing a formula for a sumif problem
Brenda,

Your problem is not so much the formula but the cells that contain the hours for each call. Since they contain the text “hrs” (for example “2.25hrs”) this turns the whole cell to text, not numeric, which will always add up to zero in Excel. So do two things:
- Change the cells in column H (Time Spent) to numeric (2.25 instead of 2.25hrs) – you might want to change the column header to Time Spent In Hrs just to b clear
- Use this formula =SUMIF(E8:E26, 1, H8:H26)
For the formula change the middle number to correspond to the operator ID – for example for operator 2 change the formula to =SUMIF(E8:E26, 2, H8:H26)

This should do it.

BTW, sent you a similar email about this.
Read full answer
May 07, 2009 • Microsoft Excel 2007 Home and Student...
1helpful
1answer

SERIAL NO OF BILL
Place the numer to be update in one cel
In anither cel say cel=cel+1 because of the alpha "S" here you need to combine 2 things.
3 formulas in excel.
right string
add 1 to val(3charactersfromright)
combining s with converted new serialnumer
Personally I prefer Foxpro for these tasks.
For large amount of numbers this is no excel task.
Have no english excel here. Look up the easy function types.
You need no visual basic for this.
Read full answer
Apr 10, 2009 • Microsoft Excel for PC
0helpful
1answer

I need a free vbag activation code
151113908966337141113908566397
Read full answer
Mar 12, 2009 • Nokia 6600
0helpful
1answer

Excel formulas
insert a row above row 1 and use data>filter>autofilter
view your database however you like
Read full answer
Nov 18, 2008 • Microsoft Excel for PC
0helpful
1answer

Computer
Any formula in Excel starts with the equals sign ("="). This is how Excel distinguishes between formulas and literal values. Knowing this, you can create lots of formulas using the usual operators of +, -, * and / for addition, subtraction, multiplication and division, respectively. Please see the examples below.

Add 1 + 1: =1+1
Add the contents of cell A1 to the contents of cell B1: =A1+B1

Subtract 2 - 1: =2-1
Add the contents of cell A1 from the contents of cell B1: =B1-A1

Multiply 1 times 2: =1*2
Multiply the contents of cell A1 times the contents of cell B1: =A1*B1

I hope this resolves the question. If not, please let me know.
Read full answer
Aug 08, 2008 • Microsoft Computers & Internet
0helpful
1answer

Excel formula of vlookup
hi there
this is i found for you ...and i hope this would give you what you are looking for..

http://www.contextures.com/xlFunctions02.html

All the Best.

Was this solution helpful? Show your Appreciation by rating it:
Read full answer
Feb 20, 2008 • Computers & Internet
0helpful
2answers

FORMULA FOR TEXT FORMATING
Yes of course, if you have a little background of visual basic programming that's possible you can enhance your requirements.

Please see link http://www.techonthenet.com/excel/questions/cond_format1.php
Read full answer
Nov 29, 2007 • Microsoft Excel for PC
Not finding what you are looking for?

View Most Popular

Excel for PC

  • Computers & Internet

Related Question

How to Add Month To Date Excel?

  • Computers & Internet

Related Topics

186 views

Ask a Question

Usually answered in minutes!

Popular Questions

CSV file to Import correctly into Excel 2003

Microsoft Excel for PC

Indian Rupee format in Excel spreadsheet

Microsoft Excel for PC

How to select all sales entry in tally 9 and how to delete it

Microsoft Excel for PC

Excel file opens in read only mode

Microsoft Excel for PC

Using excel to solve problem by trial and error method

Microsoft EXCEL 2004 for Mac

Check Out the Mobile Browsers Report
Check Out the Mobile Browsers Report

View all Fixya Reports

Top Microsoft Computers & Internet Experts

Grand Canyon Tech
Grand Canyon Tech

Level 3 Expert

3867 Answers

k24674

Level 3 Expert

8093 Answers

Brad Brown

Level 3 Expert

19187 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...