View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rod Rod is offline
external usenet poster
 
Posts: 108
Default Conditional formulas


I have two conditions and I would like to know what formula to use in the
following situation:

The conditions a
6 1 ( note 6 and 1 are contained in individual cells next to each
other,lets say Column A = 6 and Column B = 1)

If the two neighbouring cells met the above condition then I would like
Column C to return the result 1 .

Please help me with a formula for the cell in column C.

Thanks
Rod