View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ConfusedNHouston ConfusedNHouston is offline
external usenet poster
 
Posts: 41
Default Combining IF and OR Functions

I want to write a statement that effectively does the following:

IF Cell-value = A OR B OR C, THEN ENTER 1000

Ideally, I'd like to nest a 2nd and 3rd statement using this logic

Like:

IF Cell-value = A OR B OR C, then enter 1000, IF Cell-value of the same cell
= D OR F, then enter 2000, IF Cell-value of that same cell = Z, then 0

Can I do this? If so, what is the proper syntax?

Thanks