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
|