Hi all,
I'm working on creating a formula for a small snippet of a greater spreadsheet.
My goal here is to tie the statements into a nice little end yes or no.
The work put in is a two-step process so one person says true or false on if the person (with the task ID) is an executive or not. The second step is another person validating this response by saying yes or no to a 'is this answer correct' question.
snippingsnipper.PNG
The flow of this would be as follows
Step1=T-->Step2=T-->Yes
Step1=T-->Step2=F-->No
Step1=F-->Step2=F-->Yes
Step1=F-->Step2=T-->No
Any help would be appreciated! thanks,
Harrison