Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hmm... You mean the below is a truth table and you want the If statement for
A, B and C that produces this result? But we're missing part of the table. Let me redraw it like this and you fill in the missing parts: TRUE,TRUE,TRUE:? TRUE,TRUE,FALSE:TRUE TRUE,FALSE,TRUE:TRUE TRUE,FALSE,FALSE:? FALSE,TRUE,TRUE:FALSE FALSE,TRUE,FALSE:FALSE FALSE,FALSE,TRUE:? FALSE,FALSE,FALSE:? The If statement that produces the results you want depends on how you fill in the missing parts. --- "DontKnow" wrote: if I want to set up a a sequencve ogf numbers in rows like this: A B c Resultant 1 1 0 1 0 1 1 0 0 1 0 0 1 0 1 1 Where the resulatant output only provides a high (1) for numbers in columns (A and C) or (A and B) and every other combination a low (0), how would I program something like this?? As shown above!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
IF statement inside a SUMIF statement.... or alternative method | Excel Worksheet Functions | |||
Reconcile Bank statement & Credit card statement & accounting data | Excel Worksheet Functions | |||
Embedding an OR statement in an IF statement efficiently | Excel Discussion (Misc queries) | |||
Can an If statement answer an If statement? | Excel Discussion (Misc queries) | |||
appending and IF statement to an existing IF statement | Excel Worksheet Functions |