I have a spreadsheet of individuals with columns as follow: first name, surname, age and then five columns broken out into various age groups: 21-35, 36-50, 51-65, 65-78 and 78+. Ages automatically come from another sheet (labelled MASTER), brought over with, eg =' MASTER '!H36.
What I want is for the sheet to show an 'X' in the proper age group column for each individual, based on the age shown.
I used the formula, (say for the individual in row 4) =IF((C4>36)*AND(C4<51),"X",""), with appropriate amendments for age groups for each column and row numbers for each individual.
95% of the time, it works perfectly. For the rest, nothing happens. It's a blank row, with no 'X' showing anywhere. I have reformatted them for Numbers General, checked the text colour to make sure it wasn't showing in white or something, etc. The formula is precisely the same in the empty boxes as the ones above and below them (less row number, of course).
Any suggestions, please?
Bookmarks