The best way, is to create seperate rows for each scenario, and then "merge" cells vertically so that different rules share the common values, and the different ones constitute different branches of an "or" - this is actually more user friendly in most cases.
Alternatively, you can put a list of values in a cell, and write a function to parse them (much messier though).
On 26 Oct 2006 08:06:09 -0000, Rajasekhar Dara
<[EMAIL PROTECTED]> wrote:
Regards,
Hi,
I have a problem in creating Decision Tables.
I need to add a OR Condition in Decision Table.
like
if ((a==3) OR (b==1 and c==4))
then
<action>
How to denote the above condition in Decision Table(Excel Sheet).
Please do provide with sample excel sheet or a proper example.
Immediate response would be appreciated.
Rajasekhar Dara
Sr. Software Engineer
HP Global Soft Ltd
Bangalore
Phone: 22051018
Mobile: 9845400277
![]()
