Question about Oracle 10g Database Standard (ODBSEONUPP0)

Re: In Excel

a b c d

1 item cost qty =c1*b1

2 item cost qty =c2*b2

total =sum(d1.d2)

all quantities should be blank except for the items you want to total.

Posted on Oct 25, 2007

well follow the steps below to get your job done:

To create an option button in Microsoft Office Excel 2007, make sure that you add Option Button (form control) to the Quick Access Toolbar. To do this, follow these steps:

good luck ...:-)

To create an option button in Microsoft Office Excel 2007, make sure that you add Option Button (form control) to the Quick Access Toolbar. To do this, follow these steps:

- Click the Microsoft Office Button, and then click Excel Options.
- Click the Customize category, select All Commands in the Choose commands from list, select Option Button (form control), and then click OK.

- In Excel 2003 and in earlier versions of Excel, click Option Button on the Forms toolbar, and then draw the outline of the button on the sheet.

In Excel 2007, click Option Button (form control) on the Quick Access Toolbar, and then draw the outline of the button on the sheet. - Select any cell in the worksheet.
- In versions of Excel that are for Microsoft Windows, right-click the option button, and then click Assign Macro.

In versions of Excel that are for Macintosh, press COMMAND while you click or press CTRL while you click, depending on your operating system version. Then, click Assign Macro. - In the Assign Macro dialog box, click the name of the macro that you want to assign to the option button, and then click OK.

good luck ...:-)

Apr 08, 2010 | Microsoft Office Excel 2007

Hello this is Baris,

If you forget about the numbers and start naming your cells you can figure out your own formulas... Example :)

You buy apples, and you pay $2 per piece

in this case you have 2 numbers to find out how much you will pay.

price per apple

quantity

you have 3 apples you pay 6 dollars very simple right. 2 times 3.

Same thing in excel but this time you will just say price times quantity and excel will do the calculation for you.

Lets name your cells

Type in A1 Price

Type in B1 Quantity

Type in C1 Cost

Now, Column C is your calculation area.

Type in A2 2 (price for apples)

Type in B2 3 (quantity of apples)

Type in C2 =A2*C2 (price times quantity)

Now on, you don't have to calculate anything. You can change you price and quantity, cost will change by itself. Because the value in that cell is now related to other values in A2 and B2. I hope this gives you a starting point.

If you forget about the numbers and start naming your cells you can figure out your own formulas... Example :)

You buy apples, and you pay $2 per piece

in this case you have 2 numbers to find out how much you will pay.

price per apple

quantity

you have 3 apples you pay 6 dollars very simple right. 2 times 3.

Same thing in excel but this time you will just say price times quantity and excel will do the calculation for you.

Lets name your cells

Type in A1 Price

Type in B1 Quantity

Type in C1 Cost

Now, Column C is your calculation area.

Type in A2 2 (price for apples)

Type in B2 3 (quantity of apples)

Type in C2 =A2*C2 (price times quantity)

Now on, you don't have to calculate anything. You can change you price and quantity, cost will change by itself. Because the value in that cell is now related to other values in A2 and B2. I hope this gives you a starting point.

Sep 30, 2009 | Microsoft Excel for PC

This could happen if your workbook is being shared.

1. Make a backup copy of your workbook (Excel file).

2. Open it in Excel

3. Check under__T__ools > Share Work__b__ook and see if the "Allow changes by more than one user..." option is selected. If so, try unchecking it and save the workbook

4. Check the file size under**File > Properties > General tab**

Another possibility is that there are a lot of unused cells with "invisible" formatting. To check that you can try pressing**Ctrl+End** and see where the end of your document is. If it is way beyond your current work area, select those extra columns and rows and go to **Edit > Clear > All** (Note: This will delete everything on those cells)

1. Make a backup copy of your workbook (Excel file).

2. Open it in Excel

3. Check under

4. Check the file size under

Another possibility is that there are a lot of unused cells with "invisible" formatting. To check that you can try pressing

Aug 19, 2009 | Microsoft Office Excel 2003 for PC

As long as your list in Excel is formatted without missing cells in column format with a header in the cell directly above your first list time. i/e if your list is in Column A and you have 500 entries, I am assuming Cell C1 is the column header, and cell C501 is the last item of your list.

An easier way to view items similar would be to go to Data/ Filter and automatic filter.

In the arrow or list format in Cell c1 - select custom, in the pop up box you can filter the contains to highlight smaller elements of your list.

An easier way to view items similar would be to go to Data/ Filter and automatic filter.

In the arrow or list format in Cell c1 - select custom, in the pop up box you can filter the contains to highlight smaller elements of your list.

May 01, 2009 | Microsoft Excel 2003 (065-03992) for PC

It is possible. But you need to write a macro to map the selected item number to price.

Jan 26, 2009 | Microsoft Excel for PC

{=max(if(category column = category in query, price data column))}

Nov 18, 2008 | Microsoft Excel for PC

This achieved like this.

In sheet one there is cell where you input discount percentage say for exaple it cell B5. Now this cell needsto formatted to percentage(click location B5 and then right click and select format cell .On number tag select percentage). Also in cell C5 put 75 and it will write 75% as it formated to show percentage.

Let us look at one product and then you can apply the same principle to all products.

Go to sheet2. This will contain full price in one cell and discount price.Let us say full price is in location B10 and you want the discounted price in C10.

Now if the discount is 30 % then obiously you are paying 75% of full price.

To display discount price in sheet2 at C10, you need to enter this formula in C10

C10*sheet2!$B$5

Now as soon as your the discount changes C10 will change to reflect the discount rate.

In sheet one there is cell where you input discount percentage say for exaple it cell B5. Now this cell needsto formatted to percentage(click location B5 and then right click and select format cell .On number tag select percentage). Also in cell C5 put 75 and it will write 75% as it formated to show percentage.

Let us look at one product and then you can apply the same principle to all products.

Go to sheet2. This will contain full price in one cell and discount price.Let us say full price is in location B10 and you want the discounted price in C10.

Now if the discount is 30 % then obiously you are paying 75% of full price.

To display discount price in sheet2 at C10, you need to enter this formula in C10

C10*sheet2!$B$5

Now as soon as your the discount changes C10 will change to reflect the discount rate.

Sep 03, 2008 | Microsoft Excel for PC

If I am doing price analysis and have List Prices but want to formulate the whole sheet that it will calculate 30% of prices to give me trade prices

How can I do this

How can I do this

Sep 02, 2008 | Microsoft Excel for PC

Hi Chinnu,

For this you will have to install an Add-in called Analysis Tool Pack.

Kindly follow the below instructions:

1. Open Excel Options (Menu-Excel Options)

2. Click on Add-Ins on the side pane of the Excel Options Window

3. Check to see if Analysis ToolPak is in Inactive application add-in list.

4. If is not, proceed to Step 7

5. If it is in the inactive application add in list, Select Excel Add-ins against Manage and click on "Go"

6. In the add-ins menu check Analysis ToolPak and Analysis ToolPak VBA and click OK

7. Use this formula to find the number of work days excluding Saturday & Sunday in a month

=NETWORKDAYS(start_date,end_date, [Holidays])

In your case give the start date as 1st July and end date as 10th July and Holidays as 0 or 1 (doesn't matter). The answer it will return will be 8 days.

Trust the above helped.

For this you will have to install an Add-in called Analysis Tool Pack.

Kindly follow the below instructions:

1. Open Excel Options (Menu-Excel Options)

2. Click on Add-Ins on the side pane of the Excel Options Window

3. Check to see if Analysis ToolPak is in Inactive application add-in list.

4. If is not, proceed to Step 7

5. If it is in the inactive application add in list, Select Excel Add-ins against Manage and click on "Go"

6. In the add-ins menu check Analysis ToolPak and Analysis ToolPak VBA and click OK

7. Use this formula to find the number of work days excluding Saturday & Sunday in a month

=NETWORKDAYS(start_date,end_date, [Holidays])

In your case give the start date as 1st July and end date as 10th July and Holidays as 0 or 1 (doesn't matter). The answer it will return will be 8 days.

Trust the above helped.

Jul 23, 2008 | Microsoft Office Professional 2007 Full...

75 people viewed this question

Usually answered in minutes!

I have a Base Fixture that cost $100

The 20Watt lamp cost $10

The 40Watt Lamp cost $20

The 60wat lamp cost $30

The 100Watt Socket cost $50

The 100watt Lamp cost $ 40

The optional Lens Filter cost $5

I want a Base fixture $100

With a 100Watt Socket $50

and a 100Watt Lamp $40

and a Red lens Filter $5

I click on the desire check list and I want to see the Total $195

How do I do this in Excel?

×