How long will it take to earn x amount

[Hughesy39]

Hi,

I was wondering if someone could help me. I have a spreadsheet with items listed in the top half (B3:B6), along with their prices (C3:C6). In in the bottom half, listed is how much I earn in x amount of hours (B9:B13), along with how much (C9:C13).

Based on how much I earn, I want to the spreadsheet to tell me, in cells D3:D6, how long it would take until I could afford to but each item.

Thank you in advance.

Hughes39.

 

[martindwilson]

since you earn 100 an hour its simply price/100

 

[Hughesy39]

Thank's for the quick reply. I see what you mean by just using the C9 cell to calculate the times. My example was simplified as far as I could go. What I really have is something like:

...so if I divided C3 by C9, I get 0.081761. I have tidied it up by saying =if(C3/C9 < 1,"Less than 1 hr",C3/C9)

Thanks for your enlightenment. I just needed another pair of eyes to look at it

Hughesy39.

 

[FormR]

If you can order your earnings descending this may work for you:-

Excel Workbook
	B	C	D
2	Item	Price	Time
3	Item A	100	1 Hour
4	Item B	150	2 Hour
5	Item C	175	2 Hour
6	Item D	200	2 Hour
7
8	Time	Earned
9	7 Hour	700
10	6 Hour	600
11	5 Hour	500
12	4 Hour	400
13	3 Hour	300
14	2 Hour	200
15	1 Hour	100
Sheet1

 

[Hughesy39]

FormR, thanks for your input. I will have a look at this and see how it compares.