IF formula

[flyaround67]

Hi there,

I want to create an IF formula around the following assumption. If there's a better formula, that would be great.

I need to create a percentage the moment the patients get enrolled. For all patients onboarded in the first year (lets say 5,000 patients), the royalty % is 20%. For all cumulative onboarding after the first year, patients receive 3%.

[mehmetcik]

You need to provide a better explanation.

Either you mean

a: First year = 20% all subsequent years = 3% If years is in A1 then =if(A1=<1,0.2,0.03)

or

b: First year = 20% each subsequent year adds a further 3% until year 28 when 100% is reached.

[flyaround67]

Thanks for getting back to me! I think I am referring to plan a) above. What I do know is we are assuming 5,000 patients and a 5 year plan.

So we are going with a 20% allocation in the 1,000 patients in the first year of patient onboarding, and 3% onboarding for the remaining 4 years or 1000 patients. BUT, if we add new patients in year 2 or 3 then they receive 20%.