Question about Computers & Internet

Ad

I twill be better if you can just get me the excel file, so that I can edit it and send it back to you to avoid any complications. Please upload it to a file sharing site like megaupload or something so that I can download it and solve your problem.

Posted on Oct 06, 2010

Ad

Still, this is beyond the scope of a fixya problem. You are going to need to consult with excel forums and try to locate an excel consultant to help you write this custom formula. This is not something we do here.

Thanks

Tim

Posted on Oct 06, 2010

Ad

Hi,

A 6ya expert can help you resolve that issue over the phone in a minute or two.

Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.

The service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).

click here to download the app (for users in the US for now) and get all the help you need.

Good luck!

Posted on Jan 02, 2017

Hide All

Percentages are calculated by using the following equation:

amount/total = percentage

Where percentage is in decimal format.

What do you want to do?

Calculate the amount if you know the total and percentage
For example, if you purchase a computer for $800 and there is an 8.9% sales
tax, how much do you have to pay for the sales tax? In this example, you want to
find 8.9% of 800.

Example
The example may be easier to understand if you copy it to a blank
worksheet.

- Create a blank workbook or worksheet.
- Select the example in the Help topic.
**Note**Do not select the row or column headers.

Selecting an example from Help - Press CTRL+C.
- In the worksheet, select cell A1, and press CTRL+V.
- To switch between viewing the results and viewing the formulas that return
the results, press CTRL+` (grave accent), or on the
**Formulas**tab, in the**Formula Auditing**group, click the**Show Formulas**button.

Calculate the percentage if you know the total and amount For example, if you score 42 points correctly out of 50, what is the percentage of correct answers?

Example The example may be easier to understand if you copy it to a blank worksheet.

- Create a blank workbook or worksheet.
- Select the example in the Help topic.
**Note**Do not select the row or column headers.

Selecting an example from Help - Press CTRL+C.
- In the worksheet, select cell A1, and press CTRL+V.
- To switch between viewing the results and viewing the formulas that return
the results, press CTRL+` (grave accent), or on the
**Formulas**tab, in the**Formula Auditing**group, click the**Show Formulas**button.

Simple way Amount/Total*100

Apr 30, 2011 | Computers & Internet

This is too complicated for a help site like this, you are going to want to consult an excel forum, or some excel professional in your area. This is far beyond the scope of what you can expect for $15, which I'm sure you now realize after 10 days of trying.

Thanks

Tim

Thanks

Tim

Sep 26, 2010 | Microsoft Excel for PC

Using a time format for the data cells and data that looks like 12:00:10 AM the result you want is displayed no matter which formula is used. If the date portion of the data cell is not deleted then the result is 00:00:00. Delete the date portion of your data cells to get the result you want. (For example: When I enter 10 into a cell that is formated for time xx:xx:xx it shows 1/11/1904 12:00:00 AM in the formula bar and 00:00:00 in the cell. When I delete 1/11/1904 in the formula bar and show only the 12:00:10 the cell shows 00:00:10. Then it makes no difference which formula you use.)

Sep 19, 2009 | Microsoft OFFICE 2003 BASIC OEM ENGLISH MS...

Subtraction can be done in two ways in Office using the following formulas in the formula (fx) bar:

The SUM formula subtracts by changing the sign of the reference. Remember the sign rules, and thus - -x is in effect +x.

- =A1-A2
- =SUM(A1,-A2)

The SUM formula subtracts by changing the sign of the reference. Remember the sign rules, and thus - -x is in effect +x.

Jul 08, 2009 | Microsoft Office Excel 2003 for PC

VLOOKUP(A1,Sheet2A2:B20,2,FALSE)

The assumption here is A1 in Sheet 1 is the cell you want to reference, This cell can be pasted - Any problems let me know.

The assumption here is A1 in Sheet 1 is the cell you want to reference, This cell can be pasted - Any problems let me know.

Jan 21, 2009 | Microsoft Excel for PC

Hello ycool11,
If your asking what i think you are the formula would be

=(a2-a1)*24

That assumes a2 is that last date entered and a1 is the initial starting date. if you would like a more intense formula let me know and i'm sure i can help.

=(a2-a1)*24

That assumes a2 is that last date entered and a1 is the initial starting date. if you would like a more intense formula let me know and i'm sure i can help.

Oct 22, 2008 | Microsoft Excel for PC

I'm assuming you'd like to assign a numerical value to cardinal references (1st, 2nd, 3rd, 4th, etc.).

Best way to do this is to create a quick lookup table on a separate sheet of the same .xls document. Down at the bottom of the page, click on Sheet2 and create a quick table where column A has 1st, 2nd, 3rd, etc. and column B has your values.

Now click back to Sheet1 where your data is and in A2 put this formula:

=VLookup(A1, Sheet2!$A$1:$B$x, 2, FALSE)

Note: replace the lower case x in the formula above with the number of the last row of data in your lookup table on Sheet2.

You can copy and paste this formula down the column to calculate your other values.

Hope that helps!

Terry

Best way to do this is to create a quick lookup table on a separate sheet of the same .xls document. Down at the bottom of the page, click on Sheet2 and create a quick table where column A has 1st, 2nd, 3rd, etc. and column B has your values.

Now click back to Sheet1 where your data is and in A2 put this formula:

=VLookup(A1, Sheet2!$A$1:$B$x, 2, FALSE)

Note: replace the lower case x in the formula above with the number of the last row of data in your lookup table on Sheet2.

You can copy and paste this formula down the column to calculate your other values.

Hope that helps!

Terry

Aug 30, 2008 | Microsoft Excel for PC

for example, cell A1 has date (01-01-2008) and cell A2 has current date (08-24-2008) and cell A3 shows total days, is that you want to know? if yes, apply formula as under...

cell A3......(properties set as General to show digits)................ =SUM(A2-A1)

cell A3......(properties set as General to show digits)................ =SUM(A2-A1)

Aug 25, 2008 | Microsoft Office Professional 2007:...

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.

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.

Aug 08, 2008 | Microsoft Computers & Internet

If Sale Line 100 is an Excel Template then it is simple.

The Templates are just preformatted spreadsheets which are edited just like any other spreadsheet.

If you mean that you are using the Template to create another document but wanting all the fields to be the same as the Invoice then I suggest the following method:

Copy the Template fron Worksheet 1 onto Worksheet 2.

Add and remove any fields that you wnt to add or remove (Prices would be deleted on this copy and the title would be changed from Invoice to Delivery Docket, etc)

Then (on Worksheet 2) in the fields that you want to be the same - click on the cell you want the same Data in and hit the = sign. Then go to Worksheet 1 and Click on the cell that you want the data to be the same. Hit Enter. This will send you back to Worksheet 2 and you will see that any data entered into the cell in Worksheet 1 will now also appear in Worksheet 2.

Repeat this process for all the cells you want copied from worksheet 1.

When you complete the data in Worksheet 1 (the Invoice) all the data selected will automatically appear in the cells selected on Worksheet 2.

Try this on worksheet 2 select cell A1, type =, then open worksheet 1 and select B1. You will be returned to worksheet 2 and the formula in cell A1 will now read =Sheet1!A1. Enter anything into Shhet 1 A1 and you will see that it appears in the appropriate cell on Sheet 2.

When you want to print off the Invoice and the Delivery Docket - you only have to open each Worksheet and hit Print and a copy of each worksheet will be printed giving you an Invoice and a Delivery Docket with the appropriate info on each printout (eg if you exclude prices from the Del. Docket then after completing all the details in the Invoice will create a Del Docket with all the relevant information other than the prices.

Does this answer your question?

The Templates are just preformatted spreadsheets which are edited just like any other spreadsheet.

If you mean that you are using the Template to create another document but wanting all the fields to be the same as the Invoice then I suggest the following method:

Copy the Template fron Worksheet 1 onto Worksheet 2.

Add and remove any fields that you wnt to add or remove (Prices would be deleted on this copy and the title would be changed from Invoice to Delivery Docket, etc)

Then (on Worksheet 2) in the fields that you want to be the same - click on the cell you want the same Data in and hit the = sign. Then go to Worksheet 1 and Click on the cell that you want the data to be the same. Hit Enter. This will send you back to Worksheet 2 and you will see that any data entered into the cell in Worksheet 1 will now also appear in Worksheet 2.

Repeat this process for all the cells you want copied from worksheet 1.

When you complete the data in Worksheet 1 (the Invoice) all the data selected will automatically appear in the cells selected on Worksheet 2.

Try this on worksheet 2 select cell A1, type =, then open worksheet 1 and select B1. You will be returned to worksheet 2 and the formula in cell A1 will now read =Sheet1!A1. Enter anything into Shhet 1 A1 and you will see that it appears in the appropriate cell on Sheet 2.

When you want to print off the Invoice and the Delivery Docket - you only have to open each Worksheet and hit Print and a copy of each worksheet will be printed giving you an Invoice and a Delivery Docket with the appropriate info on each printout (eg if you exclude prices from the Del. Docket then after completing all the details in the Invoice will create a Del Docket with all the relevant information other than the prices.

Does this answer your question?

Apr 25, 2008 | Computers & Internet

May 24, 2018 | Computers & Internet

May 24, 2018 | Acer Computers & Internet

30 people viewed this question

Usually answered in minutes!

Pls help to write an MS excel formula: Create a worksheet 1 with below data, Cell A1 input USD, Cell B1 input 200, Cell C1 input 60, Cell A2 input RMB, Cell B2 input 15000, Cell C2 input 450, Cell A3 input RMB, Cell B3 input 10000, Cell C3 input 250, Create worksheet 2 to display the following data, Cell A1 input 'Total no. of RMB transactions : ' write a formula in Cell B1 to count the total of RMB in worksheet 1 column A, the result is 2. Cell A2 input 'Total amount : ' write a formula in Cell B2 to sum the total of RMB amount in worksheet 1 column B, the result is 25000.

×