Changing lookup form numbers to alphabetics
 

I am using this formula (=IF(G27+K270,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.

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

HTH
Jason
Atlanta, GA

-----Original Message-----
I am using this formula (=IF(G27+K270,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.
.

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

Vaya con Dios,
Chuck, CABGx3


"troubled48075" wrote in message
...
I am using this formula (=IF(G27+K270,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.