Thread: calculate a field based on value of another field
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
dlb1228 dlb1228 is offline
external usenet poster
  
Posts: 7
Default calculate a field based on value of another field
i have a column with race information in it for example

black 1
white 2
asian 3
white 2

i would like to calculate the field next to it to a number for example if
its black then put a 1 in the cell, or white = 2, asian = 3
Reply With QuoteReply With Quote