Dynamic Targets

I want to develop a "dynamic target" for the jobs per day which works something like:

If our monthly target is 4.0 paid jobs and day 1 of the month we hit 3.0 the target should move to 4.1 (or whatever the calculation is)

If we hit 4.5 on day 1 the target moves down to 3.9 (or similar).

Can anyone offer me some help?

Thanks
Mark

I want to develop a "dynamic target" for the jobs per day which works something like:

If our monthly target is 4.0 paid jobs and day 1 of the month we hit 3.0 the target should move to 4.1 (or whatever the calculation is)

If we hit 4.5 on day 1 the target moves down to 3.9 (or similar).

Can anyone offer me some help?

Thanks
Mark

You can use an if statement such as

if(day1<4, target + .1 (this is if ithe first statement is true), if (day1>4, target -1, 4 (this is if the second if is false))

try that out. day1 is the cell with the number of paid jobs, target is the cell wit the target sales. hope that works

Threads merged.

marko71, please read the Forum Rules before starting your next thread.