Percentage to exceed 100

[mikeyscoops]

Hello All,

I have seen multiple articles to limit percentage values to 100%, I need mine to exceed this. Here's what I have in place...

' = E9/B9 '

Thank You!

 

[S.H.A.D.O.]

Welcome to the board.

Perhaps you could give us some more details, like what sort of data is it, what you want to do if there is a divide by zero or error etc.

 

[mikeyscoops]

Thank you for the warm welcome!

I want to create a spreadsheet to set quarterly goals. If the employee exceeds the goal, it should be reflected in the percentage amount.

This is what I have so far:

Please let me know what other information you would need! I'm a newb!

Thank You

 

[mikeyscoops]

Apparently I cant copy images correctly either!

 

[63falcondude]

A simple division can show values over 100%.

Excel 2010
	A	B	C	D
1	Employee	Sales	Goal	%
2	Matthew	123	200	62%
3	Mark	231	200	116%
4	Luke	88	200	44%
5	John	630	200	315%
Sheet1

Cell Formulas
Range	Formula
D2	=B2/C2

 

[mikeyscoops]

The formula for G9 is:
= E9/B9
(B9 is $534,654, E9 is $80,000, G9 is 14.96%)

G9 also is formatted for percentage, obviously. If you look at the bottom row, cell B15 (126), and cell E15 (204) should make cell G15 161.90%... instead it gives me ######.

[/URL][/IMG]

 

[63falcondude]

The number is simply being cutoff. Make the column larger.

 

[mikeyscoops]

Well, that's embarrassing.

Thank you!

 

[63falcondude]

Well, that's embarrassing.

Thank you!

Happens to the best of us. You're welcome.