Excel Busn Math 12: Multiplying & Dividing In Excel

Hi there,

My question is as follows: I have data which I need to divide, then multiply by a percentage.

For example: I wish to divide A1 by B1, then multiply this total by a percentage in C1. Preferably, I would like to do all of this in one cell.

I have been trying A1/B1*C1, but I believe I need to seperate the first calculation from the second one?

Is this relatively easy to do? Any help would be appreciated! I am using Excel 2007 and happy to provide any further information.

What I am needing is a formula to list the result of multiplying cell A1 by.75 in cell B1, and then divide cell B1(the result of A1) by 52, which the result will be in Cell C1. For example:

Cell A1 is $50,000, and it is the only cell that has information typed in on the sheet. I enter the formula I need. Now Cell B1 shows $37,500( or 50,000x .75), and Cell C1 shows 721.15( or 37,500 /52).

The formula I am asking for will fill B1 and C1 with the appropriate information.

Any help would be great.

Thanks,

CB

I want to create a function which defines a pulse wave that rises from
0 to 1, stays at one for a bit, lowers to 0, and stays at zero for a
bit.

/ if (t mod 1) <0.25, V(t) = 4* (t mod 1)
| if 0.5 >= (t mod 1) > 0.25, V(t) = 1
V(t) = |
| if 0.75> =(t mod 1) > 0.5, V(t) = 1-4* (0.75-(t mod 1))
\ if 1 > (t mod 1) > 0.75, V(t) = 0

For this pulse wave there are straight rises, falls and flat bottoms
and tops, which I need (and which is why a sine wave can't be used). If
you're still with me, thanks.

I can either put this all into a long excel equation for each cell that
I want this in (there will be about 4 'if' statements and 6 'mod'
statements) or create a UDF, where the t mod 1 only has to be
calculated once.

Any idea out there how much faster/ slower as UDF really is in a case
like this? Also, can you think of an easier way to create this pulse
wave?

As a side note, the t in my program has some ROW() and COLUMN()
dependence, and there will be 200+ cells filled with this equation
(thus, I can't just compute it once and copy the values to each cell).
Caculation speed is important because each cell is being calculated as
the time, t, is advanced by a timer.

Thanks in advance to anyone who takes a stab at this.

-Abe

Why does excel and my calculator come up with different answer when
multiplying numbers with decimal points? Excel seems to be off by a couple
hundreths of a point.

Hi guys have a strange problem I have 2 worksheets the first worksheet has 3 applicable columns, and the second worksheet is simply to hold data.

The first applicable column is the number range data validation for every cell in that column, which 6,8,10,12,16,20,25,32,40,50 the data validation is hidden in the second work book and the code: =Specification!B15:B25

This then depending on which number selected feeds a different answer to the second applicable column.

the second applicable column on worksheet 1 is a vlookup which has the code
=VLOOKUP(E10,Specification!$I$15:$J$24,2,0)

This also works fine then in the next column I want to multiply the third applicable column which can be any number self inputted from 1to100 so I have done a simple equation =R10*H10, I have tried this with =sum(

and I get results for numbers 6,12,16,20,50, I don't get a #VALUE! error for the number 8,10,25,32,40

I do hope someone can shed some help,

Thanks in advance

I'm trying to use the .forumla function, yes... i need to use it... and when I type in the following, I get an error:

Code:

 Cells(k, 189).formula = "=if(AW"&k&"/GE"&k">.95,"X","")"

As most of you know, it says, if aw/ge > 90%, return X, else return blank...

Thanks in advance!

Not very proficient in Excel, not familiar with terms at all or how to set up formulas.

Problem:

I have a column of all different numbers, column F. How do I divide all numbers in Column F by 9 and make all of the answers appear in Column G? Any help would be very much appreciated. Thanks a lot.

If anyone can help me on this it would be greatly appreciated.
I need to divide a user entered hieght by several different sizes
the sizes being 3.0m,2.5m, 2.0m, 1.5m, 1.0m and 0.75m
eg; 10m hieght i would need 3 x 3m and 1 x 1m.
I realize this is probably fairly simple but for the life of me i just can't seem to figure out the formula.

Hi
I hope you can help me! An acquaintance of mine has two pivot tables.
Essentially they both analyse the same data. One is in whole numbers (Pivot 1)and the second is in percentages.(Pivot 2) She was wondering if it was possible to multiply these two pivot tables by each other so that she has a third pivot table that shows the figures from Pivot 1 multiplied by the percentages in Pivot 2. At the moment she is using copy and paste special to do that. I was wondering if it could be done in some sort of array way..
I'm not sure that it can be done without some sort of code...
All help appreciated!

Anne :

Everytime I put a figure into excel it is dividing the value by 100. i.e if I put in 200 it returns 2, if I put in 375 it returns 3.75

I am using Office 2003 and I have tried unistalling and reinstalling but no joy. It is happening against every cell so must be a global change setting, but I can't seem to loacte the setting. Any help would be much appreciated.

Thanks in advance

Steve