View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
MTHowse MTHowse is offline
external usenet poster
 
Posts: 2
Default Excel formula Help

I know this is simple but I do not know how to make it work.
Column A, B and C contain numbers, Column E contains letters A, B, C, D.
What I want to do is if Column E contains A then Column D=C*3 if Column E
contains B then Column D=C*2, etc.

--
Thanks,
Mike