View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ann ann is offline
external usenet poster
 
Posts: 210
Default IF / Else Statement?

This should be simple, but I'm drawing a blank here. I four different
categories with four different values and need to populate my field (in this
case, N19) based on the value for that category:

IF H19="IET" then C4, or H19="BUS" then C7, or H19="DSO" then C10, or
H19="BPO" then C13.

Can you assist in providing an appropriate formula structure for the above?