Question about Oracle 10g Database Standard (ODBSEONUPP0)

In Excel I have a list of Items with prices on them I have the cost of the product and below I have the cost of extra options Is there a way to see what the total sum will be if the user selects items 1,5  and 8 and see the new subtotal?

Posted by on

• Juancarloz Oct 29, 2007

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?

×

Anonymous

• Level 2:

An expert who has achieved level 2 by getting 100 points

MVP:

An expert that got 5 achievements.

Novelist:

An expert who has written 50 answers of more than 400 characters.

Governor:

An expert whose answer got voted for 20 times.

• Expert

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

• Anonymous Oct 29, 2007

I am not aware of a method that allows you to add a quantity simply by clicking the item that you want to add. Typing "1" in the quantity column next to the items you want to tally is doing essentially the same thing. In the total column you multiply the cost column by the quantity column. If the cost is in cell b1, and the quantity is in cell c1, the the formula in the total column should be =b1*c1.  Any row that doesn't have a quantity will be ignored and the sum at the bottom of the total column should be for only the items that you "Checked" by placing a 1 in the QTY column.

The formulas I offered above are for an excel spreadsheet. If you use these formulas your spreadshett would look like the following example:

ITEM                 COST     QTY     TOTAL

Base Fixture      100         1          100

20 watt lamp        10                        0

40 watt lamp        20                        0

60 watt lamp        30                        0

100 watt socket    50         1           50

100 watt lamp       40         1           40

lens filter                5         1             5

total      195

×

×

my-video-file.mp4

×

Related Questions:

Contact direct. The model gives no other hits apart from this

https://www.flickr.com/photos/[email protected]/28045784500/

Products - Webley & Scott

https://www.webleyandscott.com/collections/all
Products. Home; / Products. Grid List. Sort by: Name, A-Z, Name, Z-A, Price, low to high, Price, high to low. View as: 12 Items/page, 16 Items/page, 32 Items/page ... Missing: tr ‎ka ‎4542

Air Rifles - Webley & Scott

https://www.webleyandscott.com/collections/air-rifles Air Rifles. Home; / Air Rifles. Grid List. Sort by: Name, A-Z, Name, Z-A, Price, low to high, Price, high to low. View as: 12 Items/page, 16 Items/page, 32 Items/page ...Missing: ka ‎4542
Webley Scott TR 12 Google Search

Nov 28, 2017 | Cars & Trucks

How do I set up an account?

The first thing is that you should describe your item clearly and completely. Check the ISBN, UPC or product number and make sure that ALL details match with what is listed on Amazon website.

Make sure that your price is reasonable. You cannot expect to sell an item in the price that you originally bought it. For books I would say you may expect getting 20-30% of original price. However it varies from book to book. Sometimes a book is really rare that you can sell it for double the price that you originally bought it and sometimes you should reduce your price a lot.

Make sure to check your items and see if your item is the lowest price or not. For the beginning you should probably expect little money and as time passes by you get more feedback from people and hence you can expect selling more items with better price.

Amazon maintains consistency, i.e. they do not tend to make changes often. This is good for you as a seller since changes cost time. When changes are made, they tend to stick and sellers
can adjust. Here are more tips for selling on amazon which helps you to increase sell on amazon.

Nov 24, 2010 | Amazon Stores

How to create macro button in microsoft excel 2007 because

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:
1. Click the Microsoft Office Button, and then click Excel Options.
2. Click the Customize category, select All Commands in the Choose commands from list, select Option Button (form control), and then click OK.
To create an option button and to assign a macro to it, follow these steps:
1. 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.
2. Select any cell in the worksheet.
3. 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.
4. 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.
When you click the option button, the macro will run.

good luck ...:-)

Apr 08, 2010 | Microsoft Office Excel 2007

Steps to figure out formulas in excel

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.

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

Search options in drop down menu

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

Excel formulas

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

Nov 18, 2008 | Microsoft Excel for PC

Formulate Sheets for Price Analysis

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.

Sep 03, 2008 | Microsoft Excel for PC

Help I dont know mutch of excel

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

Sep 02, 2008 | Microsoft Excel for PC

Work day

Hi Chinnu,

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

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

Related Topics:

80 people viewed this question

Level 2 Expert

Level 3 Expert