Prev: Time format shows default of 12:00 AM
Next: Pivot Tables: Don't show data for detail, but still show subto
From: Dee on 7 Feb 2010 20:20
I need to match criteria in two separte columns and then the third colum with
be fixed text if the criteria matches eg
A1= Yes and B1=Yes then C1(column with the formula in) would show "Generate
Letter"
From: Jacob Skaria on 7 Feb 2010 20:50
Using AND()
=IF(AND(A1="Yes",B1="Yes"),"Generate Letter","")

Using COUNTIF()
=IF(COUNTIF(A1:B1,"Yes")=2,"Generate Letter","")

--
Jacob


"Dee" wrote:

> I need to match criteria in two separte columns and then the third colum with
> be fixed text if the criteria matches eg
> A1= Yes and B1=Yes then C1(column with the formula in) would show "Generate
> Letter"
 | 
Pages: 1
Prev: Time format shows default of 12:00 AM
Next: Pivot Tables: Don't show data for detail, but still show subto