=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.
|