I have a number of cells that currently have formulas that output text-fractions ie: "3 / 4" (with space before and after /). I am trying to convert these to a % ie: 75%
I've tried using
* ="="&C9 but this outputs '=3 / 4' as text
* =FIXED(C9,0,TRUE) but this outputs the numeric date quivalent of 40272
* A number of different variants using Indirect() but keep getting #REF! errors
I'm trying to do this without VBA if at all possible.
Any suggestions?
WT
Arithmetic Challenged
1) -8055.00 / -23445.00 = 34.36%
2) 60267.55 / 173953.28 = 34.65%
Should #1 above actually be a negative percent?
Hi,
I have cell c11 which displays the value either 8/4 or 4/4. I need to have cell c12 get the value that is in cell c11 but I need it to convert to the whole number that results from dividing the fraction. How can I get cell c12 to display a 2 when cell c11 is 8/4 and a 1 when cell c11 is 4/4.
Thanks.
Let say I have 7/24 as a fraction and I'd like to find 2 fractions that give 7/24 as answer when product is done.
What i need to do is find the multiple of 7 and 24 and make all the combinaition...that's what I do on the paper but any idea how to do it in Excel?
Example:
7/24=7/3*1/8
7/24=7/8*1/3
7/24=7/6*1/4
and so on...
Jasmin
ASC function shows the Ascii value of a given character.
However if it shows up for example a value of 65 the lenght of the ASC equivalent is 4 characters.. How can i set this command to show each given character's ASC value such as 0065 in 4 digit format..
I'm using an assessment that gives results in age equivalents. The format is y.m, so that a value of 5.6 means 5 Years and 6 Months. I need a formula (not a built in function) that will convert these age equivalents to age in decimals.
So, for example, the age equivalent 5.6 expressed as a decimal would be 5.5 since 6 months is 1/2 a year. An AE of 5.3 would be 5.25 since 3 months is a quarter of the year.
Any ideas?
I like to set NOW() and UUID function within Excel is this possible?
I need to increase the numerator of a percent to a new percent by a numercial increase. For example, I need to increase 45/204 (22%) to 29%. Of course if you increase 45 to 29% by adding 14 (45*29%) to it, it also impacts the total in the denominator and only increases the percent to 27%. I know the real answer is 20. 45+20/204+20 = 29% but how do you write this in a formula. Thanks.
Dear All,
I am attempting to design a query / report that shows a count of projects by project portfolio and by the projected date that they will pass a certain approval point. For each project record, I am capturing the 4 key projected milestone dates for each project as well as the project portfolio; each milestone date & portfolio have their own column defined in the table.
Therefore, I'm looking for the query / report to look like the following example (i.e. count the number of projects by project gate and by portfolio--I know that it involves using the "totals" functionality):
Portfolio Proj Gate Month 1 Month 2 Month n
Manufacturing
2 0 1 2
3 1 3 1
4 2 0 1
Marketing
2 1 1 1
3 0 3 4
4 1 2 2
Sales
2 1 1 1
3 0 0 0
4 2 2 1
Appreciate any feedback / expertise that can be provided. Thanks.
I get quite a few lists that include foreing letters and would like an automatic way to convert, say, an accented a to a normal a. I assume there will be letters to weird to convert, but for the easier ones, is there a method?
On a similar topic, in Excel, when I type: =code(cellref) I get a nice code number. When I try doing this in VBA using something like application.code(cellref/string) I always get an error. Is there another way to do this?
As always, thanks
