Changing lookup form numbers to alphabetics

[troubled48075]

I am using this formula (=IF(G27+K27>0,1,0) tocheck to see if one or both
columns have a number field entered, returning 1 if either/both and zero if
neither completed. I want to change the formula to check to see if either of
two cells have an x instead of the 1, putting an x if either/both previous
fields are checked, ond blank if neither is checked.

 

[Jason Morin]

=IF(COUNTIF(G27:H27,"x")>0,"x","")

HTH
Jason
Atlanta, GA

 

[CLR]

=IF(OR(G27="x",K27="x"),"x","")

Vaya con Dios,
Chuck, CABGx3