If Statement Nesting?
in [General]
|
From: ThunderBlade on 30 Mar 2010 14:28 Can You Nest an If Statment so that the Logic has to check 2 different cells before it outputs the True/False date?
From: Bob Phillips on 30 Mar 2010 14:33 You don't need to nest, use AND =IF(AND(B2="yes",C2>17), true_action, false_action) -- HTH Bob "ThunderBlade" <ThunderBlade(a)discussions.microsoft.com> wrote in message news:8A23BDEF-02A7-416E-9221-282571B34530(a)microsoft.com... > Can You Nest an If Statment so that the Logic has to check 2 different > cells > before it outputs the True/False date?
From: Mike H on 30 Mar 2010 14:36 Hi You use AND =if(and(A1=1,B1=2),Do this if true, do this if false) -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "ThunderBlade" wrote: > Can You Nest an If Statment so that the Logic has to check 2 different cells > before it outputs the True/False date?
From: JLatham on 30 Mar 2010 14:39 I'm going to say Yes. Would have helped if you had given a little more information, but yes, you can. You can use the OR() function or the AND() function to test 2 cells simultaneously, or you can simply nest IFs to test 1 cell, and if it passes/fails then check the other. Examples: A1 has weather indication (Raining or something else more pleasant) A2 has day of the week in it. You want to be informed you can go golfing/fishing if it is NOT raining and it IS Saturday: =IF(AND(A1<>"Raining",A2="Saturday"),"Go Golfing","Stay Home") or =IF(A1="Raining","Stay Home",IF(A2="Saturday","Go Fishing","Stuck at Home Again")) "ThunderBlade" wrote: > Can You Nest an If Statment so that the Logic has to check 2 different cells > before it outputs the True/False date?
From: ThunderBlade on 30 Mar 2010 17:46 Thank you to all. Everyone has pointed me in the direction that I was in need of.
|
Pages: 1 Prev: Count the number of columns on row that are not empty within a Next: If formula with dates |