since we can't see your data I will only comment on the formulas you wrote - they are almost there
IF [Question]="Q3" AND [DATA VALUES]=4 or 5 THEN 1 ELSE 0 END
IF ( [DATA VALUES]=4 or [DATA VALUES]=5) and [Question]="Q3" THEN 1 ELSE 0 END
then you can follow the format on the second formula
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
glad to help out