Hi,
Don't even know what formula I am after here. I've played around with IF and AVERAGE, but can't get this to work.
What I'm trying to do is create a spreadsheet that will keep track of a pill dosage. The dosage has to increase every 5 days, by the same amount, 20mg's. I want to be able to see what dosage a person would be on at any given day in the period.
I have attached a sample where I have manually done it, but is there a formula that can do this with a little more elegance? (Ignore the first two increases, which take place every 3 days, the default increase is every 5 days)
Thanks in advance!
Bleep
Don't even know what formula I am after here. I've played around with IF and AVERAGE, but can't get this to work.
What I'm trying to do is create a spreadsheet that will keep track of a pill dosage. The dosage has to increase every 5 days, by the same amount, 20mg's. I want to be able to see what dosage a person would be on at any given day in the period.
I have attached a sample where I have manually done it, but is there a formula that can do this with a little more elegance? (Ignore the first two increases, which take place every 3 days, the default increase is every 5 days)
Thanks in advance!
Bleep
Attachments

27 KB Views: 28