FLow Chart Logic

[abhi_dube1]

I working on long flow chart questions to define the logic.
Fowchart logic as example is:

Will th loss of function(H1)---Yes---is there intolerable risk(S)---yes--
NO
is ther intolerable risk(H2)-------yES(Schedule task...
No


This ways flow chart is long. i want this logical question ask one by one and at the end in the next colum answer should be E.G. (H1/s/Yes)

anyway to solve it..........pls help me
thanks

 

[Ruddles]

What are you actually doing: drawing a flowchart on a sheet of paper, writing formulae to go in worksheet cells, or designing VBA code?

If you have many sequential multiple-choice questions, then the logic will inevitably be quite lengthy. A flowchart may not be the best design tool - perhaps a decision tree would be better.