View Single Post
  #1   Report Post  
troubled48075
 
Posts: n/a
Default 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.