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'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!
Hi
I have numerious worksheets with tons of cells diplaying numbers as Fractions (Using Fraction Format and Macro to round the fractions to base 32). However these fractions are shown as numbers with decimals in the formula bar. I need these fractions to be seen as fractions in the formula bar. Is there a way I can overcome this problem?
Thanks and regards
KShora
Hi - I have been using Alt 0188 for 1/4. I can not find what the symbol for 1/8 and 3/8 is. Does anyone know?
Thanks! Karen
hi
using excel 2007 i am a noob got the basics i am stuck as to which way if at all possible can excel convert fractions to decimals
eg: 2/1 7/2 9/4 to 3.1 3.7 etc
or could i use fractions in an equation when i try it just keeps converting it to date format
any help if this is possible much appreciated
regards
andrew
Hi All,
I'm trying to sum fractions (#/#) to get an overall percentage, and am having some trouble with it.
Here's a quick example:
Row 1 2006 2007 2008 2009 | (desired outcome)
Row 2 0/1 0/0 1/1 0/1 | 1/3
Row 3 0/0 0/0 0/0 0/1 | 0/1
Row 4 1/1 1/1 1/1 1/1 | 4/4
Row 5 0/1 0/1 0/1 0/1 | 0/4
Basically, I am trying to calculate participation (numerator) over whether they had the opportunity to participate (denominator). The column above, "desired outcome" is what I want these fractions to add up as (but am currently having trouble with). Basically, I would like to separately sum both numerators and denominators as an aggregate fraction (percentage would work, too). Similar to a basketball player's shooting percentage over the course of different games. The COUNT and SUM functions have been useless thus far.
Thanks!!
Hi,
I know how to use the fraction format, but it displays the fraction as, for example,11 3/4, where the fraction (3/4) is displayed as the same font size as the integer, 11. What I want is for the fraction, 3/4, to be smaller font than the integer, 11, AND that the 3 be above the 4 not on the same horizontal level. I can't seem to show it in this text editor, but if you go into MS Word and type 11 space 3/4 you'll get exactly what I want, but its in Word not Excel. When I copy/paste the text from Word to Excel it display exactly as I want it BUT the 3/4 is inserted as a symbol not as text or a number.
Any help is appreciated
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.
Why does Excel 2007 change SOME of my cell entries from the decimals I enter (and want to keep) to fractions? In one column I have a mixture of results, all with the same value (9.5 and 9 1/2). It is not a column-width problem.
