Two formulas help please

T

The Wolf

If the goal is $50 and the actual is $100 that would be 100% over budget?
What would be the formula to calculate the % over or under budget as the
actual changes?

And:


If a percentage is known 30% and a number is known (rent) $900 what is the
formula to calculate what the income (unknown) would need to be?
 
J

JE McGimpsey

The Wolf said:
If the goal is $50 and the actual is $100 that would be 100% over budget?
What would be the formula to calculate the % over or under budget as the
actual changes?
Click to expand...

A1: 50
A2: 100

A3: =(A2-A1)/A1

or, more efficiently:

A3: =A2/A1-1

In either case, format A3 as a percentage.
And:


If a percentage is known 30% and a number is known (rent) $900 what is the
formula to calculate what the income (unknown) would need to be?
Click to expand...

I think what you're looking for is:

B1: 30%
B2: $900

B3: =B1*B2 ===> $270
 
T

The Wolf

A1: 50
A2: 100

A3: =(A2-A1)/A1

or, more efficiently:

A3: =A2/A1-1

In either case, format A3 as a percentage.
Click to expand...

Thanks, that's what I want.
I think what you're looking for is:

B1: 30%
B2: $900

B3: =B1*B2 ===> $270
Click to expand...

Not quite. The unknown should be approximately $2,700 if we change B1 to
33%.

If the rent was $900 and a guideline is they should budget 30%. Then what
would their monthly salary have to be to qualify. The monthly salary is the
unknown. The rent and percentage of budget is known.
 
B

Bernard REY

The Wolf wrote :
Not quite. The unknown should be approximately $2,700 if we change B1 to
33%.

If the rent was $900 and a guideline is they should budget 30%. Then what
would their monthly salary have to be to qualify. The monthly salary is the
unknown. The rent and percentage of budget is known.
Click to expand...

B1: 33.33%
B2: $900

B3: =B2/B1 (or =ROUND(B2/B1,0) to have it rounded)

Always think of the reverse operation in percentage operations.

To obtain $900 from the monthly salary, you have to multiply it by 33.33%:
2700 x 0.3333 = 900

So it's easy to find out that you'll have to multiply the result te find the
monthly salary back: 2700 = 900 / 0.3333
 
J

JE McGimpsey

I think what you're looking for is:

B1: 30%
B2: $900

B3: =B1*B2 ===> $270
Click to expand...

Not quite. The unknown should be approximately $2,700 if we change B1 to
33%.

If the rent was $900 and a guideline is they should budget 30%. Then what
would their monthly salary have to be to qualify. The monthly salary is the
unknown. The rent and percentage of budget is known.[/QUOTE]

I certainly did misunderstand (I must have been thinking income to the
landlord).

In that case, just turn it around:


B3: =ROUND(B2/B1,2)
 
T

The Wolf

Not quite. The unknown should be approximately $2,700 if we change B1 to
33%.

If the rent was $900 and a guideline is they should budget 30%. Then what
would their monthly salary have to be to qualify. The monthly salary is the
unknown. The rent and percentage of budget is known.
Click to expand...

I certainly did misunderstand (I must have been thinking income to the
landlord).

In that case, just turn it around:


B3:[/QUOTE]

Thank you both for your help! They work fine.

Do you have time to explain how this works? =ROUND(B2/B1,2)

I am interested in learning, I understand the ROUND function rounds off
numbers.

If we use simple numbers for my calc

Budgeted % a1 10%
Rent a2 $10
Salary (unknown) a3 $100

If I take out the ROUND a3 returns an error. Why?
And I can't figure out what the ,2 does?
 
T

Tom Stiller

The Wolf said:
Thank you both for your help! They work fine.

Do you have time to explain how this works? =ROUND(B2/B1,2)

I am interested in learning, I understand the ROUND function rounds off
numbers.

If we use simple numbers for my calc

Budgeted % a1 10%
Rent a2 $10
Salary (unknown) a3 $100

If I take out the ROUND a3 returns an error. Why?
And I can't figure out what the ,2 does?
Click to expand...

It's time to use the "Help" menu in Excel. Search for "Round" and read
what it says.

--
Tom Stiller

PGP fingerprint = 5108 DDB2 9761 EDE5 E7E3
7BDA 71ED 6496 99C0 C7CF

Support the 2004 Million Mom March on Washington DC
Mother's Day, May 9, 2004
visit <http://www.mmm2004.org/>
 
T

The Wolf

It's time to use the "Help" menu in Excel. Search for "Round" and read
what it says.
Click to expand...

You don't think I did that? Microsoft help is about as useless as tits on a
boar hog.

The two people who answered this post were very helpful. You obviously work
for Microsoft..............
 
H

Harvey Waxman

The Wolf said:
You don't think I did that? Microsoft help is about as useless as tits on a
boar hog.

The two people who answered this post were very helpful. You obviously work
for Microsoft..............
Click to expand...

From Help:


ROUND(number,num_digits)
Number is the number you want to round.
Num_digits specifies the number of digits to which you want to round number.


I agree that the help file can sometimes leave me confused but I thought this
was one of the good ones. What did you not understand?
--
Harvey Products makers of Dinghy Dogs(TM)
The Boater's Best Friend
http://www.dinghydogs.com
Ladies' handbags and accessories
http://www.deducktibles.com
Remove thefrown to email me
 
T

Tom Stiller

The Wolf said:
You don't think I did that? Microsoft help is about as useless as tits on a
boar hog.

The two people who answered this post were very helpful. You obviously work
for Microsoft..............
Click to expand...

Your powers of observation are somewhat suspect.

From the "useless" help facility:

ROUND
See Also
Rounds a number to a specified number of digits.
Syntax
ROUND(number,num_digits)
Number is the number you want to round.
Num_digits specifies the number of digits to which you want to round
number.
If num_digits is greater than 0 (zero), then number is rounded to the
specified number of decimal places.
If num_digits is 0, then number is rounded to the nearest integer.
If num_digits is less than 0, then number is rounded to the left of
the decimal point.
Examples
ROUND(2.15, 1) equals 2.2
ROUND(2.149, 1) equals 2.1
ROUND(-1.475, 2) equals -1.48
ROUND(21.5, -1) equals 20

--
Tom Stiller

PGP fingerprint = 5108 DDB2 9761 EDE5 E7E3
7BDA 71ED 6496 99C0 C7CF

Support the 2004 Million Mom March on Washington DC
Mother's Day, May 9, 2004
visit <http://www.mmm2004.org/>
 
T

TH

See below.

TH

If the goal is $50 and the actual is $100 that would be 100% over budget?
What would be the formula to calculate the % over or under budget as the
actual changes?
Click to expand...
Yes. over-under = (actual - goal)/goal or ($100 - $50)/$50 = 1 = 100%
And:


If a percentage is known 30% and a number is known (rent) $900 what is the
formula to calculate what the income (unknown) would need to be?
Click to expand...
Not enough info.

Assuming percentage is the profit then it's simply:
Income = percentage * rent or $900 * 30% = $270

If percentage is the portion of income required to pay rent then:
Income = rent/percentage or $900 / 30% = $3,000
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS Project. Real progress of the project, % complete 1
Percentage of month passed formula 1
Weighted % Complete calculation 1
Could We Look At This One Again? 4
Percent Help 2
Formula for percentage calculation 1
IF Formula 1
Formula to create a variance percentage 1

Top