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
Bookmarks