Thanks for any help I can get with this. I have tried looking for something similar but have found it difficult to translate other responses to my problem.
I want to be able to compare a value (F6 - score) to a table of values (scores by age and gender) based on data from B6 (age) and C6 (gender) and then return either a 'low concern' or 'elevated concern' result in F7.
I started mapping it out as - If(B6=8 (years of age) & C6='male' (gender), then if (F6 (score) >42, 'elevated concern' (result)) but not really sure if this is right. I hope this makes sense.
Bookmarks