Drewmyster
Board Regular
- Joined
- May 16, 2007
- Messages
- 150
- Office Version
- 365
- Platform
- Windows
Here is the scenario;
A job is valued at £100 (or whatever amount is placed in A1).
I need a formula to work our values for days, weeks, months and year based on how many of the jobs are being completed (a variable figure in B1 which can signal per day/week/month/year).
I have tried various things and keep getting circular references.
The only figures that can and will change, is the monetary value (A1) and the quantity of jobs completed (B1).
The formula needs to be able to calculate what the jobs are bringing in per day, week, month and year.
A job is valued at £100 (or whatever amount is placed in A1).
I need a formula to work our values for days, weeks, months and year based on how many of the jobs are being completed (a variable figure in B1 which can signal per day/week/month/year).
I have tried various things and keep getting circular references.
The only figures that can and will change, is the monetary value (A1) and the quantity of jobs completed (B1).
The formula needs to be able to calculate what the jobs are bringing in per day, week, month and year.