Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
URGENT - percentage calculation
Hi,
Example: I would like to make $250, 90% of $300. This will not make sense to alot of you because as a percentage - $250 is not 90% of $300, but I am trying to test a formula in excel that I have been working on. Is there someway or formula in excel which will allow me to make, or let excel think that $250 really is 90% of $300? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
URGENT - percentage calculation
Why don't you just change 250 to 270?
Otherwise, it's hard for me to understand what you're trying to do. XL doesn't "think" 250 is 90% or any other percentage of 300 - it just calculates values. In article , Jack wrote: Hi, Example: I would like to make $250, 90% of $300. This will not make sense to alot of you because as a percentage - $250 is not 90% of $300, but I am trying to test a formula in excel that I have been working on. Is there someway or formula in excel which will allow me to make, or let excel think that $250 really is 90% of $300? Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
URGENT - percentage calculation
Jack,
I just had to try and make a similar formula. You need to use the IF function. instead of entering the True or Flase text I used a simple formula that would subtract the difference between the two. In my formula I wanted 70% to equal 0% and 100% to equal 100%. I don't have the formula with me but it was something like: =IF(D3=70,(D3-69)/(D4-69),"0") It may take a while this took me 2 hours! masonn2. "Jack" wrote: Hi, Example: I would like to make $250, 90% of $300. This will not make sense to alot of you because as a percentage - $250 is not 90% of $300, but I am trying to test a formula in excel that I have been working on. Is there someway or formula in excel which will allow me to make, or let excel think that $250 really is 90% of $300? Thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
URGENT - percentage calculation
On Aug 8, 8:24 pm, Jack wrote:
I would like to make $250, 90% of $300. This will not make sense to alot of you because as a percentage Y'think? ;-) Is there someway or formula in excel which will allow me to make, or let excel think that $250 really is 90% of $300? The formula can be as arbitrarily complex or simplistic as you want. But on the off-chance that you simply are doing a poor job of explaining what you want, the following formula rounds down to multiples of 50: =50 * rounddown(300*90%/50,0) |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
URGENT - percentage calculation
90% is simply 9/10s of some value. You CAN make a look up table and
"fake it". You may want to add some more info. Like what produces the 90%? The user? What happens if it's 80%? Or 95%? Humm, change that to, "add a lot more info". Jack wrote: Hi, Example: I would like to make $250, 90% of $300. This will not make sense to alot of you because as a percentage - $250 is not 90% of $300, but I am trying to test a formula in excel that I have been working on. Is there someway or formula in excel which will allow me to make, or let excel think that $250 really is 90% of $300? Thanks |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
URGENT - percentage calculation
I'm going to go ahead and ignore the fact that the question doesn't
make much sense. Is this what you're looking for? A1 = 0.9 A2 = 300 A3 = FLOOR(A1*A2, 50) On Aug 8, 11:24 pm, Jack wrote: Hi, Example: I would like to make $250, 90% of $300. This will not make sense to alot of you because as a percentage - $250 is not 90% of $300, but I am trying to test a formula in excel that I have been working on. Is there someway or formula in excel which will allow me to make, or let excel think that $250 really is 90% of $300? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
percentage calculation | Excel Discussion (Misc queries) | |||
'of' percentage with calculation | Excel Discussion (Misc queries) | |||
URGENT - Calculation not updating | Excel Discussion (Misc queries) | |||
Percentage calculation | Excel Discussion (Misc queries) | |||
Time calculation problem (URGENTProject due) | Excel Discussion (Misc queries) |