View Single Post
  #2   Report Post  
CLR
 
Posts: n/a
Default

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