Hey!

I was hoping, as ever, to get some advice?

I've created a spreadsheet that displays all the information by default and then the user narrows down the data to whats relevant by clicking radio buttons. For the first level of options (Option1) I can do this. Where I get stuck is trying to hide data with Option2 depending what was pressed in Option1

For example in Option1 you can have either A or B

In Option2 you can have C or D but the data shown is relevant to whether A or B was selected in Option1

I gather I need an "IF" function i.e:
IF A = true then...
IF A and C = true then...
but I can't work out the wording, please help!

Much appreciated,

James