Hi guys
]
I dont know whether this is even possible? I'm overwhelmed and burnt out by this.
Im using imaginary cell references for descriptive purposes
I want to create an excel file which can advise how often people need to have there bloods tested.
The variables are this, say in a1 a drug is to be chosen from a dropdown list, which i have produced, in another cell eg a2 the minimum frequency of the bloods is to be produced based on the word/drug in A1.
However I would like the frequency of the bloods to be affected by days between todays date a3, and the last date the drug changed a4, which is formula =a3-a4 in cell a5
The date ranges that would be of interest would be if a5 is less than 30 days, less than 90 days, less than 180 days and less than 365 days.
For look up each drug could be put in another table with the above date ranges above them and minimum testing frequncy below.
I have had some success with nested if statements but cant seem to combine ands and ifs. I have heard that Vlookup may be of use?
]
I dont know whether this is even possible? I'm overwhelmed and burnt out by this.
Im using imaginary cell references for descriptive purposes
I want to create an excel file which can advise how often people need to have there bloods tested.
The variables are this, say in a1 a drug is to be chosen from a dropdown list, which i have produced, in another cell eg a2 the minimum frequency of the bloods is to be produced based on the word/drug in A1.
However I would like the frequency of the bloods to be affected by days between todays date a3, and the last date the drug changed a4, which is formula =a3-a4 in cell a5
The date ranges that would be of interest would be if a5 is less than 30 days, less than 90 days, less than 180 days and less than 365 days.
For look up each drug could be put in another table with the above date ranges above them and minimum testing frequncy below.
I have had some success with nested if statements but cant seem to combine ands and ifs. I have heard that Vlookup may be of use?
