Hi!
I am trying to make a form for work which uses age and weight to do autocalculations and display certain information based on that information. At the moment I am using a DATEDIF-function to display the age in years, months and days. I have made it so that if the age is less than 1, it displays months etc.
I have a dataset that I want to display dependant on age.
If the age is less than zero, I want it to display according to weight instead of age (prematurity). If the age is 0-4 weeks, I want to display something else, 4weeks to 6 months something else, and etc.
Ex.
Age is 1 month and 20 days. Then I want to display f.ex. 3,5.
I have tried making different =IF(DATEDIF) functions but alas, I can't seem to find a smooth and effective way to do this.
Any help with this issue is greatly appreciated!
I am trying to make a form for work which uses age and weight to do autocalculations and display certain information based on that information. At the moment I am using a DATEDIF-function to display the age in years, months and days. I have made it so that if the age is less than 1, it displays months etc.
I have a dataset that I want to display dependant on age.
If the age is less than zero, I want it to display according to weight instead of age (prematurity). If the age is 0-4 weeks, I want to display something else, 4weeks to 6 months something else, and etc.
Ex.
Age is 1 month and 20 days. Then I want to display f.ex. 3,5.
I have tried making different =IF(DATEDIF) functions but alas, I can't seem to find a smooth and effective way to do this.
Any help with this issue is greatly appreciated!