View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default If Statement Nesting?

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?