How long will it take to earn x amount

Hughesy39

New Member
Joined
Mar 25, 2012
Messages
38
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.


2012-06-30_124741.jpg



Thank you in advance.

Hughes39.
 

Some videos you may like

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

Hughesy39

New Member
Joined
Mar 25, 2012
Messages
38
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:

2012-06-30_133337.jpg


...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

MrExcel MVP
Joined
Aug 18, 2011
Messages
6,467
Office Version
  1. 365
Platform
  1. Windows
If you can order your earnings descending this may work for you:-

Excel Workbook
BCD
2ItemPriceTime
3Item A1001 Hour
4Item B1502 Hour
5Item C1752 Hour
6Item D2002 Hour
7
8TimeEarned
97 Hour700
106 Hour600
115 Hour500
124 Hour400
133 Hour300
142 Hour200
151 Hour100
Sheet1
 

Hughesy39

New Member
Joined
Mar 25, 2012
Messages
38
FormR, thanks for your input. I will have a look at this and see how it compares.
 

Watch MrExcel Video

Forum statistics

Threads
1,123,530
Messages
5,602,200
Members
414,513
Latest member
junbuggle

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top