Question about Oracle 10g Database Standard (ODBSEONUPP0)

# Excel Formula I want to add the amounts in cells (a1,b1,c1,d1) and multiply the sum of those times tax amount of (7%) and round tax amount up from 3 decimal places to 2 such as 589.145 would be 589.15 my regular formula is =sum(a1,b1,c1,d1)*(.07) whereas I want to round the (.07) product when 5 or more Thanks

Posted by on

• Anonymous Mar 21, 2014

lets say you have a formula on cell D1 that adds cells A1 and B1. how do you make excel apply the same formula to D2 when you later on have new data for cells A2 and B2 such that immediately you put the B2 data then D2 gives you the sum?

×

Ad

## 3 Answers

• Level 1:

An expert who has achieved level 1.

• Contributor
• 2 Answers

Use the round() function to specify how many decimal places you want to display.  From the example you provided above, you could use the following formula:

=ROUND(SUM(A1:A4)*1.07,2)

The final "2" specifies that you want to display two digits to the right of the decimal point.

Posted on Oct 25, 2007

Ad
• Level 1:

An expert who has achieved level 1.

• Contributor
• 2 Answers

In the cell where the result is displayed:-
right click and select Format Cells
under the Number tab, select Accounting
(Accounting format always rounds up or down correctly, and defaults to 2 dp, with a removable currency symbol.)

Posted on Oct 25, 2007

Ad

Columns total in additin cells of rows equal are total

Posted on Oct 25, 2007

## 1 Suggested Answer

• 2 Answers

SOURCE:

Hi there,
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this 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.

Here's a link to this great service

Good luck!

Posted on Jan 02, 2017

## Add Your Answer

×

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video.

×

Loading...

## Related Questions:

1 Answer

### IS THERE A PERCENTAGE FORMULA TO USE IN EXCEL

There isn't a function for this, but the formula should be something like this:
A1: Number to increase / decrease
B1: % change
C1: 'INC' or 'DEC'
D1: =IF(C1='INC', A1+(A1*B1), A1-(A1-B1))

Nov 17, 2011 | Microsoft Excel for PC

2 Answers

### Excel farmulas

Add another colum, say D with result of B*C

Do a list of the different cat, and use sumif
For cat 0101 (in cell F1)
formula to put in G1
=sumif(\$A\$1:\$A\$7000;F1;\$D\$1:\$D\$7000) where F1 contain 0101

expand the formula for other cat. (G2, G3, etc)

You can use a assistant to extract the distinct cat from A1:A7000, sorting them and copy the result in F (Menu Data-> Filter -> elaborate filter)

Feb 16, 2009 | Microsoft Excel for PC

1 Answer

### Microsoft excel

this is done through formulas. You write them in relationship to one another. Say you put a value into B1 then you write a formula for c2 like =SUM(A1/2)which means the sum of A1 divided by 2. or you can say make a formula that is like this =SUM(A1/C1) which means the value of A1 divided by the value of C1.

Jan 10, 2009 | Computers & Internet

1 Answer

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

Aug 08, 2008 | Microsoft Computers & Internet

1 Answer

### Excel formula.....

Let's start with the 1st equation. I assume you want to be able to recalculate by changing the number of pages.

Put 65 in cell a1.
360 in b1
In C1, put the formula =a1/b1 that's your book thickness
In D1, put .02 for the cover
In E1, put the formula =C1+D1

Now you can change A1, B1,or D1 and the Total thickness gets recalculated automatically. Be careful not to type numbers into C1 or E1, or you lose the formula.

The same for the other equations - a cell for each number ("variable") and another cell for calculations.

Once you've verified the results, then you can get fancy and add titles above each field to make it easy to remember what goes where.

You may need to change the cell format to control the number of decimal places, or thousands commas. Right click on a cell and select format to see the choices you have.

Keep a backup copy of the spreadsheet in case someone (not you, of course) makes a mistake and overwrites the formula cells. You can also look into "protecting" cells to keep them from being changed.

Hope that helps.

Jul 14, 2008 | Computers & Internet

1 Answer

### Excel help

Maybe this is what you need:
=IF(A1="toilet",(B1*2),(IF(A1="bread",(B1*3),(IF(A1="star",(B1*4))))))
this is called "nested".
You can put nested if function maximum 7. (for more than 7, we should make another "trick")
if you put toilet in A1 then come the value B1*2
if you put bread in A1 then come the value B1*3
if you put star in A1 then come the value B1*4
Note: SUM(F16*0.3) is wrong. should be only (F16*0.3) or if you want to do sum --> SUM(F16:F20)

Apr 01, 2008 | Microsoft Office Professional 2007 Full...

1 Answer

### EXCEL SPREADSHEET FOR INVENTORY

Dear pauline, you can link cells in formula bar to see immediate effect of additions and subtractions in dependent boxes.

Like for example you add three numbers in three boxes A1, B1, C1 and answer is supposed to go in D1, just type =SUM(A1+B1+C1)
in D1.

now when you will change the values of a b and c boxes, the value of d1 will automatically change. for adding more numbers you can leave boxes empty so that you can fill in later to see the change in the sum box.

please press fixya if that has helped you.

Dec 11, 2007 | Computers & Internet

1 Answer

### Multiply a figure in one cell times a figure in another cell , need formula

Assuming you are in Excel or another spreadsheet application.

To multiply cell A1 by cell B1 with product in cell C1, type in cell C1: =A1 * B1

Hope this helps.

Dec 05, 2007 | Computers & Internet

## Open Questions:

#### Related Topics:

193 people viewed this question

## Ask a Question

Usually answered in minutes!

Level 3 Expert

29438 Answers

Level 3 Expert

23243 Answers

Level 3 Expert

51383 Answers

Loading...