I am trying to automate the calculation of an award based on an age category (“PVSA Age Group”) and a number of hours volunteered (“Total PVSA Hrs.”) (see chart). I think I need nested IF statements with an AND, but not sure. It’s not working so far (because I have a day job hello.) I need an output based on these two variables.

Here is the first part of my formula, attacking only the second row (we have no contenders for KID category in the first row, just the remaining 3 rows):

IF(

AND(

{PVSA Age Group}=“Teens”,

{Total PVSA Hrs}<50

),

“No award”

) &

IF(

AND(

{PVSA Age Group}="Teens”,

{Total PVSA Hrs}<=74

),

“Bronze”

)&

IF(

AND(

{PVSA Age Group}="Teens”,

{Total PVSA Hrs}<= 99

),

“Silver”

),

“Gold”

That doesn’t work. Once I get it working, I need to figure out how to concatenate the other two rows (for different age categories.). Do I eliminate the subsequent AND statements, to save them for the concatenation?