Thread: Create formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
EOB EOB is offline
external usenet poster
 
Posts: 5
Default Create formula

How do I create this Formula in cell If K6=4 then E6=1 and IF K6=3 then
E6=2 and IF K6=2 then E6=2 and IF K6=1 then E6=4?