Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 13
Default Truth Table

OK - I have 6 questions, all of which can be answered either yes or no. Is
there a way to build a macro that can determine all 36 possible scenarios for
me?

For example:
1 Yes Yes Yes
2 No Yes Yes
3 No No Yes
4 No No No
5 No No No
6 No No No

.....and so on.

We can use other values for Yes and No, say True or False, or "1" or "0",
respectively.

Any help is greatly appreciated.

Victoria
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Truth Table in Excel JimS Excel Discussion (Misc queries) 10 April 22nd 23 08:12 AM
Truth Table Victoria612 Excel Worksheet Functions 0 May 27th 10 09:43 PM
Truth Table Victoria612 Excel Worksheet Functions 0 May 27th 10 09:30 PM
Truth Table Victoria612 Excel Worksheet Functions 0 May 27th 10 09:16 PM
Looking for the truth !! Decreenisi Excel Worksheet Functions 2 January 10th 06 12:39 PM


All times are GMT +1. The time now is 10:45 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"