View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
catspore catspore is offline
external usenet poster
 
Posts: 1
Default replacing numbers in a cell

How to replace numbers in a cell eg if 1 to 3, if 3 to 2, if 2 to 3. Trying
to reverse score for questionnaire. Possible to create a formula instead of
doing manually?