Hi,
I'm collecting data from a large number of language tests. One variable is age, and students have written year of birth. However a number of students have left the question blank. In the worksheet I would like to include a formula that gives me either the age or that the information is missing.
I have simple equation in the cell to calculate age from year of birth: =2023-H3 (where H3 is year of birth).
I've been trying the IF function to get the cell to either calculate age or, through a code, like "1", to make the cell say "missing" or "n/a".
I've tried versions of =IF(H3=1,"missing","2023-H3") but unable to get it to work. (been reading/watching tutorials but not finding what I'm looking for)
(at the moment I'm leaving H3 blank when the students haven't given year of birth, but it's giving me students that 2023 years old!)
Grateful for a solution, or any suggestions on where to look!
Sam
I'm collecting data from a large number of language tests. One variable is age, and students have written year of birth. However a number of students have left the question blank. In the worksheet I would like to include a formula that gives me either the age or that the information is missing.
I have simple equation in the cell to calculate age from year of birth: =2023-H3 (where H3 is year of birth).
I've been trying the IF function to get the cell to either calculate age or, through a code, like "1", to make the cell say "missing" or "n/a".
I've tried versions of =IF(H3=1,"missing","2023-H3") but unable to get it to work. (been reading/watching tutorials but not finding what I'm looking for)
(at the moment I'm leaving H3 blank when the students haven't given year of birth, but it's giving me students that 2023 years old!)
Grateful for a solution, or any suggestions on where to look!
Sam